- Familiarizing Yourself with the Ribbon Tabs
- Understanding Workbooks and Worksheets
- Understanding Contextual Tabs
- Customizing the Quick Access Toolbar
This chapter is from the book
This chapter is from the book
This chapter is from the book
Customizing the Quick Access Toolbar
The small buttons at the top-left side of the Excel screen are known collectively as the Quick Access Toolbar. By default, the Quick Access Toolbar contains three commands: Save, Undo, and Redo. If you click the drop-down selection arrow next to the Redo button on the Quick Access Toolbar, you see that these 3 commands are only 3 of 11 available as prebuilt or built-in options. Placing a check next to any of the options that you see here automatically adds each option to the Quick Access Toolbar. So, clicking New adds the New command, and clicking Open adds the Open command. You can actually click each one of these and have all 11 options available to you in the Quick Access Toolbar. In the tasks that follow, you find out how to add commands to the Quick Access Toolbar to customize it to fit your workflow.
Add a Command to the Quick Access Toolbar
Follow these steps to add to the Quick Access Toolbar one of the commands available from the drop-down menu.
- Click the arrow to open the Quick Access toolbar drop-down to see all the existing commands you can add.
- Click the New command to add it to the Quick Access toolbar.
- You now have a New icon on your Quick Access toolbar.
)
)
Add Other Commands to the Quick Access Toolbar
You’re not limited to only the commands available on the Quick Access Toolbar drop-down menu—you can add all kinds of commands. For example, if you often work with shapes, you can add the Shapes command to the Quick Access Toolbar.
- Click the Insert tab.
- Right-click the Shapes command button.
- Click the Add to Quick Access Toolbar menu item.
Add Hidden Commands to the Quick Access Toolbar
A closer look at the drop-down menu next to the Quick Access Toolbar reveals an option called More Commands. When you click this item, the Excel options dialog box opens up with the Quick Access Toolbar panel activated. This panel enables you to select from the entire menu of Excel commands, adding them to your Quick Access Toolbar. This comes in handy if you want to add some of the more obscure Excel commands that aren’t found on the Ribbon.
- Click the Quick Access Toolbar drop-down arrow.
- Select the More Commands option.
- Choose Commands Not in the Ribbon.
- Find and select the AutoFilter command.
- Click the Add button.
- Click OK to add the command to the Quick Access Toolbar.
)
)