Search

How to change the default location of Excel Quick Access Toolbar (QAT)

The default location of Quick Access Toolbar (QAT) is on the top left side of Excel Window as shown in below image.

.Excel Quick Access Toolbar - QAT

 

You may change the default location of Excel to the bottom of Ribbon (above the Formula bar). To change the default location of Excel to the bottom of Ribbon (above the Formula bar), follow these steps.

Step 1 - Click the Customize Quick Access Toolbar (QAT) button as shown in below image.

.Customize Excel Quick Access Toolbar - QAT

 

Step 2 - Click the last menu item "Show Below the Ribbon", as shown in below image.

.Show Excel Quick Access Toolbar below the ribbon

 

Now you can see that the location of Excel Quick Access Toolbar (QAT) is changed to bottom of Excel Ribbon, as shown in below image.

.Excel Quick Access Toolbar below the ribbon

 

Related Tutorials
• Excel Ribbon explained in detail
• Excel Quick Access Toolbar (QAT)
• How to customize Excel Quick Access Toolbar (QAT)
• How to Add or Remove a Command to Excel Quick Access Toolbar (QAT) quickly
• How to Add a Command which is not in Ribbon to Excel Quick Access Toolbar (QAT)
• How to add a Macro to Excel Quick Access Toolbar (QAT)
• How to change default Macro button icon in Excel Quick Access Toolbar
• How to group Commands on Excel Quick Access Toolbar by adding Separator
• How to change the position of commands on Excel Quick Access Toolbar (QAT)
• How to reset Excel Quick Access Toolbar (QAT) Customizations
• How to Import/Export Excel Quick Access Toolbar (QAT) Customizations
• Excel Formula Bar explained in detail
• Excel Status Bar in brief
• Excel Status Bar explained in detail
• Excel Backstage View
• Excel Options Dialog Box Window