How to Customize the Quick Access Toolbar in Excel

The Quick Access Toolbar is a customizable toolbar in excel. It contains commands from different tabs. You can customize and place the Quick Access Toolbar above the Ribbon or below the Ribbon. You can add your preferred commands to the Quick Access Toolbar.


Download Practice Workbook

You can download the practice workbook from here.


7 Easy Tricks to Customize the Quick Access Toolbar in Excel

By default, the Quick Access Toolbar (QAT) is in the upper left corner of the excel window although you can change its position to suit your needs. This QAT contains a set of frequently used commands. Now, these commands may vary from user to user depending on their needs. So, we will see in this tutorial how to set up this QAT for our own work requirements.


1. Moving Quick Access Toolbar Above the Ribbon

One of the common ways to customize the Quick Access Toolbar is to move it above or below the ribbon in excel. We will see how to achieve this in the following method.

Steps:

  • First, right-click on the QAT and select Show Quick Access Toolbar Above the Ribbon.

customize quick access toolbar excel

  • As a result, this will move the QAT above the ribbon as you can see in the image below.


2. Adding a Command to the Quick Access Toolbar

If you want to add a command to the Quick Access Toolbar in Excel that you use frequently, then you can customize it as we have shown below.

Steps:

  • To start with, click on the drop-down icon and select More Commands.

adding commands to customize quick access toolbar in excel

  • Immediately, this will open the Excel Options window where you can see the Quick Access Toolbar.
  • Here, select a command from the commands list and click Add>>.
  • Now, this will add the command to the command list on the right side.
  • Finally, click OK.


3. Hiding Quick Access Toolbar

You can also customize the Quick Access Toolbar by hiding it from the excel window. Follow the steps below to do this.

Steps:

  • First, right-click on the QAT and then select Hide Quick Access Toolbar.
  • Consequently, this should hide the QAT.

hiding to customize quick access toolbar in excel


4. Changing Order of Commands

There is the option to customize the order of commands in the Quick Access Toolbar if you need it. See the steps below.

Steps:

  • For this purpose, open the Excel Options window as we showed previously.
  • Now, select a command that you want to re-order and use the up-down arrow on the right.
  • Next, once you are happy with the order, click OK.


5. Removing a Command from Quick Access Toolbar

Sometimes you may want to clear up the Quick Access Toolbar a bit by removing unused commands. You can customize the removal following the steps below.

Steps:

  • First, open Excel Options from More Commands.
  • Now, select a command that you want to remove from the right side box and click <<Remove.
  • Similarly, you can continue to remove more commands and once you are done, click OK.

removing to customize quick access toolbar in excel


6. Grouping Commands in Quick Access Toolbar

It may be a good idea to customize the Quick Access Toolbar by grouping similar commands together. Let us see how we can do this.

Steps:

  • To begin this method, open the Excel Options window as previously.
  • Next, select <Separator> from the list of commands and click Add>>.
  • As a result, all the commands that are above the Separator Line will now form a group.
  • Lastly, once you are done with grouping click OK.


7. Customize Quick Access Toolbar for Current Workbook Only

If you want to customize the Quick Access Toolbar for the current excel workbook only then this method can help you do that. Follow the steps below to see how.

Steps:

  • First, open the Excel Options window and click on the drop-down as in the image below.
  • Then, from the drop-down, select the current workbook to apply the commands.
  • Finally, click OK to confirm.

set current workbook to customize quick access toolbar in excel


Excel Quick Access Toolbar Missing

Sometimes the Quick Access Toolbar might be missing from the excel window. There can be many reasons for this. But below I will show you one of the most common ways to bring the missing QAT back.

Steps:

  • To begin with, right-click on any of the tabs and select the Show Quick Access Toolbar.

  • Consequently, this should bring the missing QAT below the ribbon as in the image below.

Excel Quick Access Toolbar Missing


Conclusion

I hope that you were able to apply the above methods to customize the Quick Acess Toolbar in excel. As you see can see, this can be done in many ways. So you should choose the one that fulfills your needs. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo