How to Customize The Quick Access Toolbar in Excel

Personalize your Quick Access Toolbar with these simple tweaks

by Vladimir Popescu
Vladimir Popescu
Vladimir Popescu
Managing Editor
Being an artist his entire life while also playing handball at a professional level, Vladimir has also developed a passion for all things computer-related. With an innate fascination... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • There are numerous options available for users to customize their Excel Quick Access toolbars.
  • Resetting the Quick Access toolbar to default will discard earlier settings.
customize quick access toolbar excel

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

The Quick Access Toolbar in Microsoft Excel brings the frequently used features to your fingertips. So, it is crucial to know how to customize the Quick Access Toolbar in Excel to create a more suitable user interface.

However, we recommend you check our guide for fixing not enough disk space error appearing on Excel.

Can I customize the Quick Access Toolbar and the ribbon in Excel?

One beautiful thing about Microsoft Office is that users can import and export customized Quick Access Toolbar from one app to another. It helps you customize the apps.

Because Excel is highly customizable, there are a couple of options to use in its toolbar, to your preference. It allows you to hide and restore the Quick Access Toolbar when working. Also, you can change the order of the commands.

Furthermore, customizing your Excel Quick Access Toolbar allows you to add or remove commands from. There are other customization options you can use, and we’ll take you through some as we go into the guide.

How do I customize the Quick Access Toolbar in Excel?

1. Show or hide the Quick Access Toolbar in Excel

  1. Launch Microsoft Excel on your computer.
  2. Right-click on the Ribbon, then select either Hide Quick Access Toolbar, or Show Quick Access Toolbar.

It allows you to call for the Quick Access Toolbar when needed and not just lie around your workspace. So, you can retrieve it if it’s hidden or hidden if it’s available.

2. Change the Quick Access Toolbar location

  1. Open Excel on your device.
  2. Click the drop-down button in the top-left corner, then select Customize Quick Access Toolbar.
  3. Select Show Below the Ribbon from the drop-down menu.
  4. You can do the same to move it above the ribbon if the Quick Access Toolbar is below the ribbon.

Changing the location of the Excel Quick Access Toolbar lets you select where it is best suited for your activities.

3. Show or Hide command labels on the Quick Access Toolbar

  1. Launch Excel on your device.
  2. Click on the drop-down button, and click Customize Quick Access Toolbar.
  3. Select either Show Command Labels or Hide Command Labels from the drop-down menu.

The condition for this customization process is that the Quick Access Toolbar must be set below the ribbon to show or hide the command labels.

4. Add a command to the Quick Access Toolbar in Excel

  1. Open Excel on your device.
  2. Click the drop-down button, then select the Quick Access Toolbar.
  3. Check the command you want to add from the drop-down menu.

The above steps can remove a command from the Quick Access Toolbar by selecting the Remove command instead of Add.

5. Use the Options command to customize the Quick Access Toolbar

  1. Launch Excel.
  2. Click File in the top-left corner, click on Options, then select Quick Access Toolbar.
  3. Use the Add button to pick items from the Choose command from the list, then add them to the Customize the Access Toolbar list.
  4. Use the Remove button to remove items from the Customize the Access Toolbar, to the Choose command from the list.

It allows you to personalize the Quick Access Toolbar to consist of only the useful commands.

6. Reset the Quick Access Toolbar to the default settings in Excel

  1. Open the Excel app.
  2. Right-click the Ribbon and click on Customize Quick Access Toolbar.
  3. Tap on Reset in the bottom-right corner, then select Reset only Quick Access Toolbar.

The steps above will reset Quick Access settings to default and clear your settings.

However, the above are a few of the many customization options you can use for the Quick Access Toolbar on Excel.

In conclusion, we have a detailed guide on fixing the Excel toolbar not showing on Windows 11. Likewise, our readers may be interested in Excel files not attaching to emails and how to fix it.

If you have more questions or suggestions, kindly drop them below in the comments section.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: