How to Show Toolbar in Excel (4 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

For our day-to-day use, we may need to hide the toolbar or the tabs in the ribbon. the reasons may be simply because of better visibility or distraction-free worksheet. But as we hide the toolbar, we also need to unhide the toolbar. How we unhide and show the toolbar in Excel are discussed below with adequate examples.


How to Show Toolbar in Excel: 4 Ways

We are going to discuss in 4 ways, how we are going to reveal or show the toolbar in Excel. We recommend you learn and apply all these methods to your Excel worksheet. It will definitely enrich your Excel knowledge.


1. Show Toolbar Using Control Buttons

Control buttons are in the corner of the Excel worksheet. You can control the visibility of tabs, command tools, etc. using this icon.

Steps:

  • As you can see, the ribbon menu toolbar on a given Excel sheet is hidden at the moment. That means there are no tabs and command tools visible now.

  • On the control button of the worksheet, click on the Ribbon Display Options.
  • After clicking on the Ribbon Display Options, an options menu will appear.
  • From the menu click on Show Tabs.

Show Toolbar Using the Control Buttons

  • Clicking Show Tabs will bring up the tabs above the formula bar.

Show Toolbar in Excel Using the Control Buttons

  • In order to add both tabs and commands, you’ll need to click the Ribbon Display Options in the control button.
  • You should see a new menu, select the Show Tabs and Commands.

Show Toolbar in Excel Using the Control Buttons

  • After clicking on the Show Tabs and Commands, you will notice that both tabs and commands tools in the Ribbon toolbar are available now.

Show Toolbar in Excel Using the Control Buttons

This is how you show both tab and command tools in the Excel workbook.

Read More: Types of Toolbars in Excel


2. Double-Click on Tabs to Show Ribbon

Just double-clicking the tabs will spawn the hidden ribbon.

Steps:

  • In the picture below you see that the ribbon toolbar menu is hidden, only the tabs are visible.

. Double-tap the Tabs to Show Ribbon to Show toolbar in Excel

  • To make them visible, double-click on any visible tab. In this case double-click on the Home tab.

  • After double-clicking on the Home tab, the Ribbon menu with the toolbar will appear.

. Double-tap the Tabs to Show Ribbon toolbar

This is how you can show the ribbon in Excel by just double-tapping any tab.


3. Show Ribbon with Keyboard Shortcut

Using a simple shortcut will reveal the hidden Ribbon in the worksheet.

Steps:

  • In the worksheet, if you notice carefully. there are no ribbons in the toolbar shown on the worksheet at this moment.

Show Ribbon in Excel with Keyboard Shortcut

  • Press the Ctrl+F1 in order to show the ribbon/ toolbar.

Show Ribbon with Keyboard Shortcut

  • As soon as you press the shortcut, you will see the toolbar and command appear.

Show Ribbon in Excel with Keyboard Shortcut

This is how you can show the toolbar in Excel.


4. Embedding VBA to Show Toolbar

Using a simple VBA can smoothly show the toolbar without any hassle. This method will need to have a Macro ready, whenever you need to show the ribbon you just have to run that Macro.

Steps:

  • First, press ALT+F11 to open the Visual Basic. After that, a new window opens.
  • Then in that window, click Insert >> Module.

  • In the Module window, enter the following code.
Sub show_toolbar()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
End Sub
  • Then close the window.
  • After that, press ALT+F8′ to open the Macro dialog box.
  • After pressing the shortcut, a new window will open containing all the macros created in that Excel file. From that window, select the macro that you created just now. The name here is show_toolbar. Then click Run.

Embedding VBA Macro to Show Toolbar in Excel

  • After clicking Run, you will notice that the toolbar in the ribbon menu is now showing.

Embedding VBA Macro to Show Toolbar in Excel

This is how you can show the toolbar in Excel just by running a simple VBA macro.


How to Add New Commands to Quick Access Toolbar

The Quick Access Toolbar can show frequently used commands that can be customized to add new commands. Using these commands available to use in palm’s reach can make Excel more fluent and smooth.

Steps:

  • To add new commands in the quick access toolbar, click on the down arrow icon.
  • Then you will see the commands that are present in the quick access toolbar.
  • Then click on the More Commands.

Add New Commands to Quick Access Toolbar

  • A new window will spawn, from the window, click on the Quick Access Toolbar.
  • Then select the command that you want to be added on the Quick Access Toolbar, then click on Add.

Add New Commands to Quick Access Toolbar

  • The new command will be shown on the right side of the window. In this case, this is the Save command.
  • Click OK after this.

Add New Commands to Quick Access Toolbar

  • Then head over to the main menu, and you will notice that the new command Save now showing properly.

Add New Commands to Quick Access Toolbar

Read More: How to Add Strikethrough in Excel Toolbar


Download Practice Workbook

Download this practice workbook below.


Conclusion

To sum it up, the question “How to show toolbar in Excel” is answered here in 4 different ways. We used shortcuts as well as VBA macro. The VBA process is also less time-consuming but requires prior VBA-related knowledge. The other method doesn’t have such a requirement. For this problem, a macro-enabled workbook is attached where you can practice these methods.


Related Article


<< Go Back to Toolbar in ExcelExcel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo