How to Show or Hide the Toolbar (Ribbon) in Excel
This tutorial demonstrates how to show or hide the toolbar in Excel.
In Excel, you can hide the Ribbon using Ribbon Display Options.
- In the top-right corner, next to the minimize button, there is the Ribbon Display Options button.
- To hide the Ribbon, click on Ribbon Display Options, then on Auto-hide Ribbon.
Now the Ribbon is hidden.
With the auto-hide setting applied, you can display tabs briefly by clicking on the three horizontal dots in the top right corner next to Ribbon Display Options, or you can press ALT.
Auto-hide Ribbon hides all Ribbon tabs. To display them again, click on Ribbon Display Options and Show Tabs.
By doing this, you return only tabs and not commands.
Show Tabs and Commands
To show tabs and commands, click on Ribbon Display Options and then Show Tabs and Commands.
Now tabs and commands are shown in the Ribbon.
There are a few other options to customize the Ribbon, including the use of VBA code.