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-06-10T21:59:54+00:00

    My situation/problems described in exact words in your first paragraph. I should be grateful to find a way to return the formula bar to the top

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-06-10T18:37:23+00:00

    Use older version. its workd for me 😎

    Can you please provide the site and actual APK that was used? I've tried a couple, and keep getting a message that that package appears to be invalid.

    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

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-06-10T15:35:08+00:00

    Use older version. its workd for me 😎

    Can you please provide the site and actual APK that was used? I've tried a couple, and keep getting a message that that package appears to be invalid.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-06-10T14:52:16+00:00

    Unbelievable.

    I ended up doing a factory reset because having the formula bar at the bottom was driving me bonkers. Which corrected the problem, since nothing else did.

    And now this morning, it's back at the bottom. I'd used Excel just the night before. No phone or Google app updates were done between using it with the formula bar at the top and then having it jump down to the bottom.

    Just wanted to add one other thing. Checked the other 2 phones within the household, and now every single one has the formula bar at the bottom. Strangely enough, all 3 phones happen to be running 3 different versions of Excel.

    16.0.14729.20146 (s21 ultra)

    16.0.15128.20112 (s10)

    16.0.15225.20216 (s21 ultra)

    W T F???

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-06-01T16:07:45+00:00

    Did you see my Update?

    What can be done, now that we KNOW that it's A FEATURE, not a BUG – & that it, of course, happens on all sheets/workbooks, new or legacy-created?

    Was this answer helpful?

    0 comments