Customizing Quick Access Toolbar

Customizing Quick Access Toolbar

The Ribbon is fairly efficient, but many users prefer to have certain commands available 

at all times, without having to click a tab. The solution is to customize your Quick Access
toolbar. Typically, the Quick Access toolbar appears on the left side of the title bar, above
the Ribbon. Alternatively, you can display the Quick Access toolbar below the Ribbon;
just right-click the Quick Access toolbar and choose Show Quick Access Toolbar Below the
Ribbon.

Displaying the Quick Access toolbar below the Ribbon provides a bit more room for icons,
but it also means that you see one less row of your worksheet.
By default, the Quick Access toolbar contains three tools: Save, Undo, and Redo. You can
customize the Quick Access toolbar by adding other commands that you use often. To add
a command from the Ribbon to your Quick Access toolbar, right-click the command and
choose Add to Quick Access Toolbar. If you click the down arrow to the right of the Quick
Access toolbar, you see a drop-down menu with some additional commands that you might
want to place in your Quick Access toolbar.

Excel has quite a few commands (mostly obscure ones) that aren’t available on the Ribbon.
In most cases, the only way to access these commands is to add them to your Quick Access
toolbar. Right-click the Quick Access toolbar and choose Customize the Quick Access
Toolbar. This section of the Excel Options dialog box is your one-stop shop for Quick Access toolbar customization.

Started with Excel

Add new icons to your Quick Access toolbar by using the Quick Access Toolbar section of the Excel Options dialog box.