Excel Basics · ~3 min read

Customize the Excel Quick Access Toolbar and Ribbon

Add your favorite commands to the Quick Access Toolbar and customize the ribbon to work faster.

Video link coming soon
What you will learn

Step by step

1. Intro

Welcome back. In this lesson, you will set up Excel to work faster, by customizing the Quick Access Toolbar and learning the ribbon tricks that save clicks.

Customize the Excel Quick Access Toolbar and Ribbon: Intro
Intro

2. The Quick Access Toolbar

The Quick Access Toolbar sits in the top-left corner, above the ribbon. It is always visible, whichever ribbon tab you are using.

By default it holds AutoSave, Save, Undo and Redo. But the real power is that you can put any command you use often right here.

Customize the Excel Quick Access Toolbar and Ribbon: The Quick Access Toolbar
The Quick Access Toolbar

3. Add commands

Click the small arrow at the end of the toolbar. This is the Customize menu.

It lists popular commands. A tick means the command is already on the toolbar. Click Print Preview and Print to add it.

A new icon appeared on the toolbar. It works from any tab, so you never have to hunt for it.

Notice that the arrow moved to the right. Let's open the menu again and add Quick Print as well.

Customize the Excel Quick Access Toolbar and Ribbon: Add commands
Add commands

4. Keyboard access

Every command on this toolbar also has a keyboard shortcut. Tap the Alt key, and little numbers appear over the toolbar.

Press Alt and that number to run the command without the mouse. Press Escape to leave this mode.

Customize the Excel Quick Access Toolbar and Ribbon: Keyboard access
Keyboard access

5. Speed tricks

A bonus time saver is F4, which repeats your last action. Select A1 and press Control and B to make it bold.

Now click B1 and press F4. The same action repeats, so B1 becomes bold too. This works for almost any command.

Undo has a drop-down too. Click the small arrow next to Undo, and you see your latest actions.

Pick one of them, and Excel undoes everything back to that point. We will just close the list with Escape.

Alt also shows shortcut letters for the ribbon. Tap Alt, then press H, and look at the letters above the Home tab commands.

Every ribbon command can be reached with letters like these. You already used some: Alt, H, O, R renames a sheet, and Alt, H, B, A adds borders.

The ribbon has one more control at its far right: Ribbon Display Options. It lets you choose how much of the ribbon is visible.

What should you add? A good starting set is Print Preview, Sort A to Z, Paste Values, and Format Painter.

Shortcut: F4

Customize the Excel Quick Access Toolbar and Ribbon: Speed tricks
Speed tricks

6. Add from the ribbon

You can add any command from the ribbon. Right-click a button, for example Bold.

Choose Add to Quick Access Toolbar, and the button is copied there. We will just look at the menu for now.

The same menu has Customize the Ribbon, where you can build your own tab, and Collapse the Ribbon.

Customize the Excel Quick Access Toolbar and Ribbon: Add from the ribbon
Add from the ribbon

7. Collapse the ribbon

Press Escape to close the menu. Now let's try collapsing the ribbon with Control and F1.

Only the tab names remain, so you get more room for your data. Click a tab, and the ribbon appears temporarily.

Press Control and F1 again to bring the ribbon back permanently.

Customize the Excel Quick Access Toolbar and Ribbon: Collapse the ribbon
Collapse the ribbon

8. Remove commands

Finally, tidy up. To remove a command, open the menu and click the ticked command again. We will remove Quick Print.

And the same for Print Preview and Print. Our toolbar is back to normal.

Customize the Excel Quick Access Toolbar and Ribbon: Remove commands
Remove commands

9. Recap

Let's recap. The Quick Access Toolbar keeps your favorite commands one click away, on every tab.

Add commands from the Customize menu or by right-clicking a button, use Alt with a number to run them from the keyboard, and Control F1 to collapse the ribbon.

Next time, you will learn how to save, print and share your workbooks.

Thanks for watching, and see you in the next lesson.

Customize the Excel Quick Access Toolbar and Ribbon: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Rows, Columns and Borders in Excel (Resize, Insert, Delete)
Next tutorial: Save, Print and Share Excel Files (Beginner Tutorial) →