Customizing the Quick Access Toolbar
One of the features of Excel is the quick access toolbar, QAT for short. Most users of Excel know it as the tiny toolbar in the top left corner of Excel with the undo and redo buttons on it.
If you want to greatly speed up your work in Excel, then do the following:
- Right-click on the QAT and select show below the ribbon. This makes it easier to get too
- Right-click on any buttons you use and add to QAT
- You can right-click on buttons and menu items. And you can do so not only on the built-in tabs but also on the tabs we add.
- The Spreadsheet Assistant's tab gives you lots of button and menu item choices!
The more buttons you add, the less you have to go searching on the ribbon tabs for the button you want to use!
If you want to remove a button you added, Right-click on the button and select remove.
If you need to edit the QAT, right-click on it and select the customize option.