How to Show Hidden Quick Access Toolbar in Excel

This practical guide walks through how to show Hidden Quick Access Toolbar in Excel. It organizes the required steps, settings, and checks so you can complete the task with fewer mistakes.

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.

Show Hidden Quick Access Toolbar in Excel - step or example 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.

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

Select File In the Ribbon > Options > When The Options window appears, select ' Quick Access Toolbar ' (left column).
Move your mouse to ' Show Quick Access Toolbar below the Ribbon ' and uncheck this item.
Select ' OK '.

The Quick Access Toolbar Is Currently Hidden in Excel - step or example 2

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

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.

Hide the Quick Access Toolbar in Excel - step or example 3

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

Method 1: Add Command Buttons on the Ribbon

Find the command button you need to add on the Ribbon.
Open the location of the command button and Right-select the icon of the command button to add. then choose: 'Add to Quick Access Toolbar'.

Method 1: Add Command Buttons on the Ribbon - step or example 4

Method 2: Add a Command Button That Is Not Available in the Ribbon

Select the Quick Access Toolbar's down arrow.
Select 'More Commands'�
Find and select the command buttons needed for your Quick Access Toolbar.

Method 2: Add a Command Button That Is Not Available in the Ribbon - step or example 5

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 : select the command button on the bar and select Remove from Quick Access Toolbar.

Delete and Move Command Buttons for Quick Access Toolbar - step or example 6

Change Command Button Position

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

Change Command Button Position - step or example 7

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

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.

Return Quick Access Toolbar to Its Original State - step or example 8

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!

FAQ

Prepare the required device, software, account access, and any files mentioned in the steps. Back up important data before changing system settings.

Why does the process look different on my device?

Menus and options can vary by operating system, app version, device model, or region. Use the closest matching setting and check the official documentation when needed.

What should I do if a step does not work?

Restart the app or device, confirm permissions and connectivity, update the software, and repeat the step carefully. Avoid unofficial downloads or tools.