← Cheatsheets
quick access toolbarcustomizationefficiency

Customize the Quick Access Toolbar in Excel

How to customize the Excel Quick Access Toolbar to put your most-used commands one click away.

You can save a lot of time by putting frequently used commands on the Quick Access Toolbar. Little things add up — saving one to two seconds per action, many times a day, adds up to hours per month.

The same procedure applies to other Microsoft Office applications: Word, Access, PowerPoint, etc.

Adding Commands

  1. Click the File tab → Options (or click the small dropdown arrow on the Quick Access Toolbar and choose More Commands).
  2. In the Excel Options screen, click Quick Access Toolbar.
  3. In the left panel, browse All Commands and find the command you want.
  4. Click Add to move it to the right panel (your toolbar).
  5. If you added the wrong command, select it in the right panel and click Remove.
  6. Click OK to save.

Organizing Commands

Use the up and down arrow buttons on the right side of the dialog to reorder commands on your toolbar. Group related commands together or put your most-used ones first.

The Quick Access Toolbar sits above (or below) the ribbon and is always visible regardless of which ribbon tab you're on, making it faster than navigating tabs to find a command.