UPDATE: CAN'T Fix? : Formula Bar Now at Bottom of Excel (for Android) Screen

Anonymous
2022-01-15T19:25:31+00:00

Happy 2022!

A couple days ago, I opened a spreadsheet (that I update, daily), & discovered that the Formula Bar had moved to the bottom of my screen. It still does what it's supposed to, but this positioning makes life difficult in multiple ways (details below).

I can't find an update to the Excel app, or Android OS, that seems recent enough to be responsible, though the Excel screen did seem to become set, approx the same time, to match phone's day/night color schemes.

I can't find any mention, or images – online, on Microsoft.com, in tech pubs/blogs, or community forums – of this behavior, or of any way to move the Formula Bar.

Can anyone provide insight into what happened, or how to fix it?

NOTE : System + app versions follow screenshot, along with "difficulties caused" – mentioned above.

Many thanks for any solution(s?) &/or insights❗

___________________

UPDATE: This morning [22-May'22], I opened Excel, on my Android phone, & MS "asked" whether I've enjoyed the "Updated Feature: …Has your editing experience become easier having the Formula Bar at the bottom?" {see add'l att}

BINGO ❗ IT'S A FEATURE, NOT A BUG

[Does not explain why an MS rep would request info, trying to replicate the "Feature"]

————————

————————

PHONE : Samsung Galaxy S21 (5G)

OS : Android version 12 

  : One UI version 4.0

  : Android security patch 1-December'21

EXCEL (for Android) : V 1.0.1 (16.0.14729.20146)

PROBLEMS

• Decades of Excel habits, using Formula Bar at top.

• Pop-ups, while typing (suggestions, option selection, etc.), display on top of toolbar, making click/select errors – that clear all content from formula/data entry field – inevitable.

• Enlarging the Formula Bar covers bottom (typically more important) rows of spreadsheet, + makes them trickier to access.

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

114 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2023-01-09T21:53:54+00:00

    As stated before, the formula bar now switches from top to bottom depending on whether the display on my tablet is set to dark or light mode.

    Why would they do that?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-01-09T21:38:38+00:00

    Just checked the tablet and formula bar is at the top.

    Same versions, tablet at the top, phone at the bottom??????

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-01-09T12:11:05+00:00

    Hmm, will try that out, though TBH I have now got used to it, no choice really. :-(

    My devices are
    Tablet 16.0.15928.20192

    Phone 16.0.15831.20186

    However, I was having an issue that when I transferred a workbook back to my PC, I was losing data validation, but just on one column.?
    That is why I checked the versions.
    As the phone appeared to be behind the tablet (whih at last check, was at the top) I updated the phone to the tablet version, but it still removed the data validation.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-01-09T08:28:14+00:00

    Good afternoon. Not long ago I encountered this problem. I was able to find this solution. Need to download version: 16.0.14430.20246

    . Data 05. 10. 2021.

    You can use older. But not younger than the version presented

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-12-18T11:04:43+00:00

    Well I accepted the last update of Excel and mine is still at the bottom. :-(

    However, I have got used to it now, but would still like to have the choice of where to place it, rather than being told 'you will now have it here'. :-(

    Was this answer helpful?

    0 comments