This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
I am using Unlocked Samsung Galaxy s22 Ultra 1tb Red.
Latest ANDROID OS AND PATCH not any beta.
I have microsoft 365 and android version latest as you'll see in screenshots, and I too have the same issue now. Formula bar on bottom no way to alter.
See screenshots. Android 12, UI 4.1 MAY 2022 PATCH
1.
2.
3.
It depends on what phone or device you have, and you'll need to make sure you have Permissions enabled that allows for installing APKs.
I had to try multiple old APKs before finally coming across the June 19th, 2021 APK (version 16.0.14131.20166) where the formula bar is back on top. This worked on both my Pixel 3a XL and my Pixel 5a. For both of my phones, I chose the "arm64-v8a Android 8.0+ nodpi" version. Here is a link to the June 2021 APKs. https://www.apkmirror.com/apk/microsoft-corporation/excel/excel-16-0-14131-20166-release/#downloads
Praise be, it worked! Thank you, the formula bar is back at the top. But this sucks, now another app I have to make sure I don't update...
Utter nonsense to change something so important that's been there forever. Muscle memory makes me tap at the top to type and instead it highlights a column. BS. Now I have to tap the cell again AND tap the formula bar. Yeah, nope, reverted to an older version.
I last saved a document in excel on my phone on May 23rd with no problems. (Probably used it since then, but I tried resetting the app to fix the formula bar and it cleared the "recent" list. Pretty sure I used it more recently.) Opened it today, June 11th, and the formula bar is at the bottom. Haven't had an issue until today. And people were having in issues back in January? Am I lucky I've gone so long?
I thought this was the reason, if wrong, then I'm wrong,
then there is no way around it, Excel for Android will stay with Formula bar at the bottom until Microsoft changes that.
WRONG!!
Automatic updates ARE turned off, so that scenario didn't happen.
It also doesn't explain how with 3 phones in the household, all with the formula bar at the bottom now, and all 3 have different versions of Excel.
And now you're implying that Microsoft thinks it's a good idea, and purposely put the formula bar at the bottom, when they denied this when we first complained about it, and after decades of it being at the top? Maybe they should read some of the comments at the Google play store.
You have the automated update, once you reinstalled it , it was the older version, during the night it has been updated, therefore the new version has the formula bar at the bottom, if you disable the automated update, you will still be on the older version, this will be a trade off, of keeping the formula bar at the top with older version or update it and have the most updated version (currently the formula bar at the bottom).
Hope that helps!