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.
- 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.
- 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.
Read More: How to Add a Macro to Your Quick Access Toolbar in Excel
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.
Read More: How to Hide Toolbar in Excel (3 Quick Methods)
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.
Read More: How to Remove Quick Access Toolbar in Excel (3 Easy Ways)
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.
Read More: How to Add Strikethrough in Excel Toolbar (3 Easy Ways)
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.
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.
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.