Forum Discussion
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, the ribbon is collapsed, and the Headings and Formula Bar are hidden.
Today, I have noticed the Formula Bar has been re-enabled and there seems to be no way to get rid of it. The Ctrl-F1 hotkey for hiding the ribbon does not seem to be working either. I can still remove the Formula Bar via the View tab in a local Excel file. However, there is no option to do so anymore in Excel Online, which we need to use. I am at a loss as to what has happened. Am I missing something?
7 Replies
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
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
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.
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)
