Customizing the Quick Access Toolbar

The Quick Access Toolbar may be small, but you can pack a lot of tools onto it. If you are stuck using a small screen, or if you prefer an uncluttered workspace, you can set up the Quick Access Toolbar as a sort of “ribbon lite” to help free up some screen real estate.

Positioning the Toolbar

When you first start Excel, the Quick Access Toolbar appears above the ribbon, as shown in Figure 3-10. You can change this so that the toolbar appears below the ribbon. Click the Customize Quick Access Toolbar button (the little arrow at the right end of the toolbar), and click Show Below The Ribbon. When you do, the name of the command changes appropriately, as shown in Figure 3-11.

Figure 3-10. The Quick Access Toolbar ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.