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
    2022-07-22T16:05:24+00:00

    INCREDIBLE? LATEST UPDATE:

    This Week [20-Jul'22], I opened my DAILY Excel pain|meds|phys therapy workbook/sheet…

    —

    ⭐ [last Excel update 12-Jul'22, "Version 16.0.15427.20090", VZW service]⭐

    NOTE: Switched to Z·Flip3 5G, ~5 weeks ago (mid-June); SmartSwitch moved essentially everything, incl Excel Formula Bar 'feature' (moved to bottom of screen).

    —

    …&, for, perhaps, most of an hour, FORMULA BAR WAS BACK AT TOP OF MY SCREEN, IN EXCEL FOR ANDROID, for data entry / wks cleanup;

    Seemed swell, til a problem with another app* required a phone Restart.

    NOW: Formula Bar is back (consistently) at bottom of screen.

    —

    Whiskey, Tango, … ❓

    _______

    *For anyone interested / any possible connection, FedEx's app flaked on logged-in info query screen. Reset, reinstalled, to no avail, ultimately uninstalled & now use their website via Chrome for Excel.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-15T17:05:35+00:00

    Same with me on my Samsung A12 (bottom) and Teclast tablet (top)

    Both have the same versions. Making sure if I use the tablet version (seldom), that I am not on the internet. :-)

    I do not want to get that updated.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-07-15T12:19:25+00:00

    Also experiencing this on my iPhone 12 Pro iOS 15.5

    But NOT on my iPad same iOS 15.5

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-07-10T11:00:11+00:00

    I am not over reacting at all. I am clarifying my comment to you as you seem you did not understand what I wrote. The poster stated that Windows was not affected, I raised that windows is different and it is not affected, but the android systems is affected, the original poster did not understand that the issue affected only the android, I am sure my first comment was clear and did not need any clarification, I just wrote to explain more,

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-07-10T08:09:57+00:00

    In Android, touch the three dots top right, and choose Settings.

    Scroll down to Send Feedback

    Was this answer helpful?

    0 comments