how to unhide toolbar in excel

Reveal Excel's Hidden Toolbar in a Snap

By Sarah Moore
AD

Ever found yourself scrolling left and right to view all the data in your Excel worksheet? Or wishing for a clearer view by hiding the toolbar, only to realize you'd like to have it back? No worries, unhidden in no time. Here's a comprehensive guide on how to unhide the toolbar in Excel.

Before we dive in, let's quickly cover why you might have hidden it in the first place. The Excel toolbar, or Ribbon, can be quite extensive, which sometimes leads users to hide it to maximize workspace. But when you need it back, there are several ways to do so, depending on your Excel version and the method you previously used. Let's explore them.

Unhide the Ribbon via Excel Options

This method is applicable for Excel 2007 and later versions.

AD
How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy
How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy
How to Hide and Unhide Rows and Columns in Excel
How to Hide and Unhide Rows and Columns in Excel
How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy
How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy

First, click on the 'File' tab in the top-left corner of your Excel window. Then, navigate to 'Options' at the bottom of the menu.

Customize Ribbon

In the pop-up window, select 'Customize Ribbon' on the left sidebar. Microsoft offers a variety of tabs and groups in the ribbon that you can customize or totally unhide.

How to Remove Spaces in Excel
How to Remove Spaces in Excel
a computer screen with the words don't remove blank rows manual
a computer screen with the words don't remove blank rows manual

To unhide a specific tab or group, check the box next to it in the list. To minimize the ribbon, uncheck all the boxes, and then recheck only the boxes for the items you want to show.

Show Developer Tab

Sometimes, the 'Developer' tab may be hidden. This is particularly useful if you're working with VBA macros or XML coding. To show it, click on 'Customize Ribbon', then check the box for 'Developer' in the list.

AD

If you're not sure what it is or how to use it, you can ignore it for now. Just knowing how to show it is important. To explore the Developer tab, click on it after following the above steps and click on 'Visual Basic' to access Excel's programming language if you're up for the challenge.

Unhide the Ribbon via Quick Access Toolbar

This method works for Excel 2007 and later versions as well.

The Quick Access Toolbar offers options to show or hide selected commands. Here's how to do it:

AD

Customize Quick Access Toolbar

First, look for the Quick Access Toolbar at the top-left corner of your Excel window, just above the 'File' tab. Click on the small dropdown arrow next to it to access its settings.

Select 'Show Below the Ribbon' or 'Show Above the Ribbon' to reposition the toolbar. If you want to customize the commands it displays, click on 'More commands...'

Add or Remove Commands

In the 'Choose commands from' dropdown, select 'Commands not in the Ribbon'. This will show you a list of commands that you can add to the Quick Access Toolbar.

AD

To add a command, select it and click on 'Add' followed by 'OK'. To remove a command, select it and click on 'Remove' followed by 'OK'.

Now that you know how to unhide the Ribbon, you can maximize your productivity in Excel. Next time you need to hide it for better workspace, you can easily unhide it whenever required. Happy analyzing!

AD