A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Give it time. It will change. :-)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Give it time. It will change. :-)
Hi all. I too prefer the formula bar being at the top as it used to be. But thankfully I'm learning to live with it being at the bottom. One thing I thought I should mention to all those who must have it at the top. Recently I installed the Office (Microsoft 365) app for Android. It opens excel, pdf and word files and maybe others not sure. Anyway when I opened one of my spreadsheets with it, low and behold the formula bar was at the top. Other than that it appeared to be set out exactly like the Excel app.
What size screen is that on?
I have 365 on my tablet (data entry bar at the top) and on my phone (data entry bar at the bottom)
On my brand new laptop with a brand new 365 the data entry bar is at the top is where it should be - at the top - but on my Samsung it's still at the bottom.