How to show hidden Quick Access Toolbar in Excel

Quick Access Toolbar (Excel) is also known as the quick access toolbar in Excel. It, provides quick customizations to common command buttons that users frequently use. In Excel's interface, the default location of the Quick Access Toolbar is in the top left corner. This bar can be moved, hidden and shown as you wish.

How to show hidden Quick Access Toolbar in Excel Picture 1

Note: The Ribbon is the main toolbar and the Quick Access Toolbar is a small toolbar containing commands that users frequently use. Using Quick Access Toolbar, you do not need to switch between tabs on the Ribbon.

The Quick Access Toolbar is currently hidden in Excel

How to show Quick Access Toolbar Excel is very simple, less than 3 seconds.

1. Click File in the Ribbon > Options > When the Options window appears, select ' Quick Access Toolbar ' (left column).
2. Move your mouse to ' Show Quick Access Toolbar below the Ribbon ' and uncheck this item.
3. Click ' OK '.

How to show hidden Quick Access Toolbar in Excel Picture 3

Immediately, the Quick Access Toolbar will appear again in its default state.

Hide the quick access toolbar in Excel

Quickly use the mouse to hide the Quick Access Toolbar.

=> First select the Quick Access Toolbar in Excel. In the drop-down list, select ' Show below the Ribbon '.

Immediately the Quick Access Toolbar is hidden in Excel.

How to show hidden Quick Access Toolbar in Excel Picture 5

Ways to adjust Quick Access Toolbar you need to know

In modern calculations, fast operations are extremely necessary. If you grasp the Quick Access Toolbar, your work will be more convenient and easier. Here are a few important instructions for you to grasp that.

Add command button to Quick Access Toolbar

Method 1: Add command buttons on the Ribbon

1. Find the command button you need to add on the Ribbon.
2. Go to the location of the command button and Right-click on the icon of the command button to add. Then select: 'Add to Quick Access Toolbar'.

How to show hidden Quick Access Toolbar in Excel Picture 7

Method 2: Add a command button that is not available in the Ribbon.

1. Click the Quick Access Toolbar's down arrow.
2. Select 'More Commands'…
3. Find and select the command buttons needed for your Quick Access Toolbar.

How to show hidden Quick Access Toolbar in Excel Picture 9

Delete and move command buttons for Quick Access Toolbar

For simplicity, you can remove command buttons from the Quick Access Toolbar when you don't need to use them too much. At the same time, you can move the position of the buttons to make them more eye-catching.

How to delete : Click on the command button on the bar and select Remove from Quick Access Toolbar.

How to show hidden Quick Access Toolbar in Excel Picture 11

Change command button position: 

1. Open Quick Access Toolbar options: File > Options > Quick Access Toolbar.
2. In the Customize option box, select the command button you want to move > press the up or down arrow until it reaches the desired position. (Follow the picture).

How to show hidden Quick Access Toolbar in Excel Picture 13

(*) If you want to group command buttons, add them between command groups! [Choose command from: Popular Commands/ /Add/press arrow to move position].

Return Quick Access Toolbar to its original state

There are times when the Quick Access Toolbar is hidden in Excel due to too much manipulation by someone. So you can return it to its original state to rearrange.

Select the Reset button and select 'Reset only Quick Access Toolbar'.

Everything will be returned to its original state for you to begin other customizations.

How to show hidden Quick Access Toolbar in Excel Picture 15

There are also many ways for you to add special function keys such as adding Macros. Because the way to add it is quite complicated and lengthy, see you in another article. The instructions will be more detailed.

I hope the information on how to display the Quick Access Toolbar will be useful to you. Leave a comment if you need further support!

Marvin Fry

Update 03 June 2024