How to add a command to the Quick Access Toolbar
You can add commands as you want to your Quick Access Toolbar like this.
Below is an example of a customized quick-access toolbar 👇
There is no limit to adding commands to your Quick Access Toolbar but not all commands will be visible depending on the size of your screen 💻
Let’s customize your Quick Access Toolbar!
Open your practice workbook to get started.
- In your Quick Access Toolbar, click the drop-down button.
The drop-down list will show you popular commands you can add to your Quick Access Toolbar. Some of these commands include New, Open, or Email commands and more..
Let’s add the New File command to our Quick Access Toolbar.
- Click the New option.
There it is! You have added a new command to your Quick Access Toolbar 👍
By adding the New File command, you don’t have to go to File Tab and click the New option to create a new workbook. You can just click the New File command button.
Add more commands to your Quick Access Toolbar, it’s certainly not limited to one 😉
Add more commands to the Quick Access Toolbar
If you don’t see the function you want in the list, there are tons more hidden away in a menu.
You can find more when you click the More Commands button in the drop-down list.
- Click the drop-down arrow again.
- Click More Commands to customize the quick access toolbar.
The Excel Options Window will appear showing you all the commands you can add to Quick Access Toolbar. You will be surprised how many commands there are in Excel 🤯
You can choose commands from the Popular Commands, Commands Not in the Ribbon, All Commands, and even Macros! If you’re looking for a specific command in the Excel ribbon tabs, you can do that too.
For now, let’s choose commands from Popular commands. Say, we are going to add the Calculate Now command.
- Click Calculate Now.
- Click Add.
It will appear in the next box.
You will see the newly added commands in the quick access toolbar 😊
Now you can access them easier and faster. You don’t have to look for them in the specific ribbon tab they belong to👀
Alternatively, you can open the Excel options window when you right-click the QAT and Click Customize Quick Access Toolbar.
This will automatically open the Excel options window so you can do QAT customizations.