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

%3CLINGO-SUB%20id%3D%22lingo-sub-2217035%22%20slang%3D%22en-US%22%3ECan%20No%20Longer%20Use%20Ctrl-F1%20and%2For%20Hide%20Formula%20Bar%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217035%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20our%20office%2C%20we%20use%20Excel%20Online%20to%20display%20a%20schedule%20on%20a%20relatively%20large%20screen.%20We%20have%20it%20worked%20to%20display%20the%20perfect%20amount%20of%20rows%20display%20for%20viewing%2C%20but%20only%20when%20full-screen%20is%20on%2C%20the%20ribbon%20is%20collapsed%2C%20and%20the%20Headings%20and%20Formula%20Bar%20are%20hidden.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%2C%20I%20have%20noticed%20the%20Formula%20Bar%20has%20been%20re-enabled%20and%20there%20seems%20to%20be%20no%20way%20to%20get%20rid%20of%20it.%20The%20Ctrl-F1%20hotkey%20for%20hiding%20the%20ribbon%20does%20not%20seem%20to%20be%20working%20either.%20I%20can%20still%20remove%20the%20Formula%20Bar%20via%20view%20in%20a%20local%20Excel%20file.%20However%2C%20there%20is%20no%20option%20to%20do%20so%20anymore%20in%20Excel%20Online%2C%20which%20we%20need%20to%20use.%20I%20am%20at%20a%20loss%20as%20to%20what%20has%20happened.%20Am%20I%20missing%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2217035%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2217114%22%20slang%3D%22de-DE%22%3ESubject%3A%20Can%20No%20Longer%20Use%20Ctrl-F1%20and%2For%20Hide%20Formula%20Bar%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217114%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1000240%22%20target%3D%22_blank%22%3E%40ngiuliano1996%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EExcel%20Online%20has%20limited%20functionality.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20can%20use%20this%20link%20to%20navigate%20through%20all%20of%20the%20Excel%20Online%20shortcut%20functions.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1297749992%22%20id%3D%22toc-hId-1297749992%22%3E%3CFONT%20size%3D%223%22%3EMicrosoft%20Excel%20-%20Excel%20Online%20keyboard%20shortcuts%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fkb.nmsu.edu%2Fpage.php%3Fid%3D74905%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fkb.nmsu.edu%2Fpage.php%3Fid%3D74905%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--509704471%22%20id%3D%22toc-hId--509704471%22%3E%3CFONT%20size%3D%223%22%3EKeyboard%20shortcuts%20in%20Excel%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fkeyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Ftopic%2Fkeyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

@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-9b7213...

 

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.

@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)

 

 

 

 

 

 

 

 

 

 

 

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.
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.

@ngiuliano1996 

Perhaps, I'm not active with Excel Online. Simplified ribbon was some ago here, after that disappeared and now is returned.

 

You may ask your question in comments to this post Simplified Ribbon is now available in Excel for the web (microsoft.com) mentioning the author who is from Microsoft.