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 No comments

114 answers

Sort by: Most helpful
  1. Anonymous
    2022-07-09T11:05:51+00:00

    Well when I first installed Excel on my Oukitel phone, it was at the top.

    When I moved to my Samsung A12, it was still on the top.

    Then all of a sudden it has moved to the bottom.

    So that theory is as much use as a chocolate fireguard. :-)

    Phone is on version 1.0.1 (16.0.15330.20166)

    Need to check the version on my laptop.

    Hmm, same version on my tablet? Go figure?

    Sent in feedback. Others should do so, perhpas they might even listen then?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-07-09T10:45:27+00:00

    You don't agree to what? to my comment??? I replied to the poster who mentioned that Window 11 is not affected, Windows 11, to my knowledge, is for computers (laptop, all in one) but not to android (unless Apple systems, I don't use Apple), I wrote that it affect the Android which is not on the computers, is that hard to understand????

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2022-07-09T07:34:43+00:00

    The formula bar is always at the top on my (Android) tablet. Excel must look at the screen resolution to determine whether to put the formula bar at the top or bottom.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2022-07-08T21:13:33+00:00

    I just opened excel on my tablet, but only after disabling my WiFi. It said updating, then Done, which would be hard with the WiFi off?

    Anyway that excel still has the formula bar at the top, so will need to remember not to use it before switching off the WiFi each time. :-)

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2022-07-08T16:45:51+00:00

    I just had my 365 subscription reminder come through. I took the opportunity to provide feedback about the issue.

    Also, I pressed the "cancel subscription" button and was automatically offered 2 months free subscription. Try it!

    Was this answer helpful?

    0 comments No comments