Quick Access Toolbar


What is the Quick Access Toolbar?


The Quick Access Toolbar is a set of icons that allows you to easily access the commands you use the most. By default the quick access toolbar only contains 4 commands but the commands it contains can be customized to suit the user.

  1. Save allows you to quickly save a file.
  2. Undo allows you to quickly undo the last command or action that was performed in the workbook.
  3. Redo allows you to quickly redo the last command or action that was undone in the workbook.
  4. Mouse/Touch Mode Toggle (only for touch screen devices) allows you to toggle between a mouse mode and a touch screen mode. In touch screen mode, commands in the ribbon are more spaced out so they’re easily accessed by touch.


Changing The Quick Access Toolbar Location



If you don’t like the default location above the ribbon then you can move the Quick Access Toolbar below the ribbon.

  1. Click on the small down arrow to the right of the Quick Access Toolbar to open the drop down menu.
  2. Select Show Below the Ribbon from the menu.
  3. Now the Quick Access Toolbar displays underneath the ribbon.


These are the only two places the Quick Access Toolbar can live and it’s restrained to being left aligned in both cases.


Adding Commands To The Quick Access Toolbar



You can add commands to your Quick Access Toolbar and you’re not restricted only to commands that appear in the ribbon, you can also add commands that don’t appear in the ribbon.

  1. Click on the small down arrow to the right of the Quick Access Toolbar to open the drop down menu.
  2. There is a selection of 12 common commands, including the 4 default commands, that can be added to the Quick Access Toolbar by checking them off in this menu.
  3. To choose from all of Excel’s available commands select More Commands from the menu.
  4. Select an option from the Choose commands from drop down menu. Commands are organised in several useful fashions, or you can choose to view All Commands.
  5. Select a command which you want to add to the Quick Access Toolbar.
  6. Press the Add button. You can also remove commands with the Remove button.
  7. Use the Up or Down arrow to rearrange the order of the Commands in your toolbar.
  8. Press the OK button.


Removing A Command From The Quick Access Toolbar



Removing a command from the Quick Access Toolbar is easy.

  1. Right click on the command you want to remove.
  2. Select Remove from Quick Access Toolbar from the menu.


Use Your Quick Access Toolbar Commands With Keyboard Shortcuts



If you like using keyboard shortcuts, you can use the commands with Alt + Number(s) keyboard shortcut. After pressing the Alt key, the numbers associated with the commands will be shown.

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.



Related Articles



Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This