How to Show the Quick Access Toolbar in Excel – 3 Methods

This is the Quick Access Toolbar:

Showing Quick Access toolbar in Excel

 


Method 1 – Applying the Ribbon Display Options

  • Click Ribbon Display Options.
  • Check Show Quick Access Toolbar or press Alt + Z + R + S.Use of Ribbon Display Options to show Quick Access Toolbar

The Quick Access Toolbar is displayed.

Quick Access Toolbar in Excel


Method 2 – Using the Context Menu of the Ribbon

  • Right-click any tab on the Ribbon.
  • Select Show Quick Access Toolbar.Context menu of Ribbon Tab

The Quick Access Toolbar is displayed.

Quick Access Toolbar in Excel

You can also right-click any command on the Ribbon and select Show Quick Access Toolbar.Context menu of Ribbon Command

Read More: Quick Access Toolbar is Missing in Excel


Method 3 – Using the Excel Options Feature

  • Click the File tab.File tab of Excel
  • Select Options to open the Excel Options window or press Alt + F + T.Select Options from Excel menu
  • In the Excel Options window:
    • Select Quick Access Toolbar.
    • Check Show Quick Access Toolbar.
    • Click OK.

    Enable Show Quick Access Toolbar option

The Quick Access Toolbar is displayed.

Quick Access Toolbar in Excel

 


Frequently Asked Questions

How to reset the Quick Access Toolbar to its default settings?

  • Go to the File tab > Options.
  • In the Excel Options window: Quick Access Toolbar > Customizations.
  • In Customizations: Reset only Quick Access Toolbar > OK.

Is the Quick Access Toolbar customizable?

Yes, you can customize it by adding or removing commands.

Can you relocate the Quick Access Toolbar in Excel?

Yes, you can relocate it below or above the Ribbon.


Get FREE Advanced Excel Exercises with Solutions!
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo