Forum Discussion

ngiuliano1996's avatar
ngiuliano1996
Copper Contributor
Mar 17, 2021

Can No Longer Use Ctrl-F1 and/or Hide Formula Bar in Excel Online

In our office, we use Excel Online to display a schedule on a relatively large screen. We have it set up to display the perfect amount of columns/rows for viewing, but only when full-screen is on, th...
excel
Excel for web
office 365
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Mar 22, 2021

ngiuliano1996 

If the ribbon isn't visible at all

If the ribbon isn’t visible at all (no tabs are showing), then you probably have it set to Auto-hide. Select More  ... at the top right of the screen. This will temporarily restore the ribbon.

When you return to the document, the ribbon will be hidden again. To keep the ribbon displayed, select one of the Show options above.

 

See also

Customize the ribbon in Office

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

 

 

 

 

 

 

 

 

 

 

 

ngiuliano1996's avatar
ngiuliano1996
Copper Contributor
Mar 22, 2021
My issue is exclusively on Excel Online. I used to be able to compress the top ribbon and hide the Formula bar to create more space for viewing the Excel sheet. I think it was via the Ctrl-F1 shortcut. This does not seem to work anymore, and the option to hide the formula bar is no longer present in the View tab.
    • ngiuliano1996's avatar
      ngiuliano1996
      Copper Contributor
      Mar 23, 2021
      I am not sure what happened then. I know I was able to use Ctrl-F1 and collapse a good portion of the ribbon and the Formula bar in Excel Online. Hiding this piece of the ribbon would allow a good 1 to 2 more rows to be visible when in full-screen. Now we have to scroll down to view some of our Excel Schedule. I am not sure what changed, but something definitely has.

Resources