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-02-07T08:49:46+00:00

    I also have this irritating issue. Some time around the start of 2022 my formula bar moved to the bottom of all Excel spreadsheets opened on my Samsung Galaxy S10. I absolutely hate it. And I find Microsoft's denial of the problem very insulting.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-01-20T01:57:25+00:00

    Add me to that list, using Samsung galaxy s21 ultra, with all updates installed. Have cleared cache, reset excel, cleared data, uninstalled, restart phone and reinstalled, etc. Can't get formula bar back up to the top. No problem on an s10, even if sharing files between the 2, so obviously something within the app (or in combo with something on the phone) versus actual files.

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2022-01-18T00:53:53+00:00

    Tin,

    Thank you – for the quick response, & suggestion.

    Unfortunately, it did not change anything. Backing up, I have a professional tech background, & should have mentioned other steps I'd already tried, when I posted. Your suggestion would still have been new, & worth trying, but, now, for the record, here are some of the other steps I've tried – some before, + some after, reading & trying your suggestion. None provided any change/improvement; I :

    • Cleared the Excel cache, in Android Settings, + Powered off & Started the phone (did not 'Restart'), before rechecking
    • Created a new blank workbook, first with my phone, then with my Win10 desktop (which has never exhibited this problem); reopening either on my phone made no difference; but either displayed fine on my desktop
    • Uninstalled Excel, then Powered off + Started the phone, before reinstalling & checking Excel
    • Since Excel's in-app Settings, on my phone, only offer "Reset Office", I first just reset Excel (Force-stopped the app, then cleared its cache + data), then Powered off + Started the phone, before opening Excel
    • Your suggestion: Used Excel's in-app Settings, to "Reset OFFICE" (I was surprised at how quickly this occurred – the app seemed ready to allow me to open a workbook, more quickly than if I'd just closed a workbook), but still no improvement, before or after restarting

    I'm still stuck, and at a loss.

    One STRANGE BEHAVIOR/observation that may be worth noting – I have a pair of Samsung Galaxy Tab S4s – that's the model that came out approximately when Office pricing changed, & has a screen that's 0.1 inch too large to qualify for a free copy of Office for Android (which is not a problem, as I don't use either for anything requiring Office functionality).

    FTR: I own/use full, legal software + licensing for local-install Office Pro and Windows 10 Pro.

    This afternoon, I became curious, & checked one of the Tabs. Initially, behind text advising that I could not save any changes without subscribing to Office 365, I could see that the function bar was at the bottom of the screen, same as on my phone. After resetting office on my phone and restarting both tablets, I checked them, & both, thru the same warning text, now show function bars at the top of the workbook page, like my desktop, + like my phone, just last week. Go figya‽

    Any further advice, suggestions, recommendations, etc., would be greatly appreciated, EXCEPT a full Factory Data Reset on my phone. That will, no doubt, at some point, become inevitable, & I will check this, then, but given the time already spent on this issue I can't afford more days, configuring my phone to be just what it otherwise is, today.

    Thank you,

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-01-26T00:21:32+00:00

    Samsung Galaxy S21 Ultra

    Glad to hearI'm not alone in this mess! I hope the engineers are actually working on finding the issue and get us a fix! And fast!!

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2022-01-18T03:07:13+00:00

    I've got the same problem on a Honor 20pro, Android 10, Magic UI 4.0.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments No comments