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
Gold Contributor
Mar 17, 2021

ngiuliano1996 

 

Excel Online has limited functionality. You can use this link to navigate through all of the Excel Online shortcut functions.

Microsoft Excel - Excel Online keyboard shortcuts

https://kb.nmsu.edu/page.php?id=74905

 

Keyboard shortcuts in Excel

https://support.microsoft.com/en-us/topic/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

ngiuliano1996's avatar
ngiuliano1996
Copper Contributor
Mar 22, 2021

NikolinoDE  Thanks for the reply. Yes I have checked those shortcut lists out. It seems the Ctrl-F1 shortcut to hide the ribbon in Excel Online is no longer doing anything for any of our online excel sheets. Perhaps this is why I can no longer hide the formula bar.

  • NikolinoDE's avatar
    NikolinoDE
    Gold 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.

Resources