The ribbon has multiple display options to fit your preferences, but with an errant click, you can unintentionally hide your ribbon.
-
To quickly show the ribbon, click any tab, for example, the Home or Insert tab.
-
To show the ribbon all the time, click the arrow on the lower-right corner of the ribbon.
For more control of the ribbon, you can change your view and maximize the ribbon by accessing the Ribbon Display Options near the top of your Excel document.
Using the Ribbon Display Options button
-
Select the Ribbon Display Options button in the lower-right corner of the ribbon.
-
In the menu that opens, select Always show ribbon to show the ribbon with all tabs and full commands.
This option is the default view. While this option provides quick access to all the commands, it can limit the available screen space for your workbook.
Note: Press Ctrl+F1 to show and hide your commands in the ribbon.
-
Select Single Line Ribbon or Show tabs only to display the ribbon tabs without the commands. To access the commands in the Single Line Ribbon option, select any of the tabs.
-
Try out different combinations of Show tabs only and Adjust automatically to find the display options you want for the tabs and commands. By using these options, you get the largest amount of screen space when you view your workbook.
Tip: You can customize the ribbon with your own tabs and commands for quick access to the toolbar features you use most.
The ribbon has multiple display options to fit your preferences, but with an errant click, you can unintentionally hide your ribbon.
-
To quickly show the ribbon, click any tab, for example, the Home or Insert tab.
-
To show the ribbon all the time, click the arrow (Excel 2013) or pushpin icon (Excel 2016) on the lower-right corner of the ribbon.
For more control of the ribbon, you can change your view and maximize the ribbon by accessing the Ribbon Display Options near the top of your Excel document.
Using the Ribbon Display Options button
-
Click the Ribbon Display Options button on the top-right corner of your document. It's to the left of the Minimize icon.
-
In the menu that opens, select Show Tabs and Commands to show the ribbon with all tabs and full commands.
This option is the default view. While this option provides quick access to all the commands, it limits the available screen space for your workbook.
Tip: Press Ctrl+F1 to show and hide your commands in the ribbon.
-
Select Show Tabs to display the ribbon tabs without the commands. To access the commands in the Show Tabs option, select any of the tabs.
-
Select Auto-hide Ribbon to hide all tabs and commands.
By using this option, you get the largest amount of screen space when you view your workbook. To access tabs and commands in this view, select the very top of your workbook.
Tip: You can customize the ribbon with your own tabs and commands for quick access to the toolbar features you use most.
