Quick access with keyboard shortcuts

Get quick keyboard shortcuts for your most frequently used command buttons on the Quick Access Toolbar.

EQ

This tip gives you a quick way to access your most used commands using keyboard shortcuts.

The Quick Tip shows how to access items in the Quick Access Toolar with the keyboard.

The Bonus Tip lets you customize which commands are included in the Quick Access Toolbar.

With the Expert Tip you can even customize it using only the keyboard!

We hope you find these tips useful.

Excel Quicker!

Quick Tip

Keyboard shortcuts for quick access

The Quick Access Toolbar sits across the top of the Excel screen or window, just above the ribbon toolbar. It is used for quick access to your most commonly used commands or toolbar buttons.

You can use the following keyboard shortcuts to access the commands or buttons in the customizable Quick Access Toolbar:

Quick Access Toolbar itemKeyboard shortcut
Item 1Alt then 1
Item 2Alt then 2
Item 3Alt then 3
Item 4Alt then 4
Item 5Alt then 5
Item 6Alt then 6
Item 7Alt then 7
Item 8Alt then 8
Item 9Alt then 9
Keyboard shortcuts to access the Quick Access Toolbar items in Excel

For example

Quick Access Toolbar example
Quick Access Toolbar example

If your Quick Access Toolbar looks like the one above, the shortcuts will be:

Example Quick Access Toolbar itemExample keyboard shortcut
Item 1: Automatically SaveAlt then 1
Item 2: NewAlt then 2
Item 3: OpenAlt then 3
Item 4: SaveAlt then 4
Item 5: EmailAlt then 5
Item 6: Quick PrintAlt then 6
Item 7: Print Preview and PrintAlt then 7
Item 8: SpellingAlt then 8
Item 9: UndoAlt then 9
Keyboard shortcut examples to access the Quick Access Toolbar items in Excel

This is only an example; the assignment of shortcuts to commands depends on which items are in your Quick Access Toolbar and the order in which they appear.

If some commands are not available, the other shortcuts do not change. For example, if “Paste” is item 3 but is not available (because you have not copied anything), then item 4 is still shortcut 4; it does not become shortcut 3.

More items in the Quick Access Toolbar

These shortcuts show you how to quickly access any of the first nine items in the Quick Access Toolbar.

If you have more, the others can still be accessed using keyboard shortcuts but will take an additional key press:

  • Alt then 0 then 9 will invoke the 10th item
  • Alt then 0 then 8 will invoke the 11th item
  • Alt then 0 then 7 will invoke the 12th item
  • Etc.

You can only have one row of items in the Quick Access Toolbar; it cannot be resized into two rows. If you fill it, any additional items then go into a dropdown button at the end.

Customizing the Quick Access Toolbar

See the Bonus tip for how to customize the Quick Access Toolbar.


Bonus Tip

Please log in to see the bonus tip.

No login?
Get one for free.

Don’t have a login?

Get a login for free on our standard plan, and get a new tip each week.

Get started >>

All logins also get access to the bonus tip each week.

Get even more

Get even more with one of our reasonably priced paid plans, with access to features like:

  • Quicksheet PDF summaries
  • Example files
  • VBA syntax
  • Additional expert tips each week
  • Advance publication

Get quicker >>

View our plans to see what else you are missing, or join for free on our Standard plan.

 

Expert Tip

Please log in to see the expert tip.

Don’t have a login? Get one.

Download files for this tip

Get Quicksheet

Quicksheet

Download example

Example file

No login?
Get one for free.

Delayed schedule

This tip is on the Delayed Schedule. It works just like normal, but it’s old news.

To view the current Tip of the week, log in with an account that has access to our Advance Publication schedule.

Don’t have a login?

Get one >>

For more information about publication schedules and access to tips, see our plans.

Share this tip