Excel 2007 for Starters: The Missing Manual

Appendix A. Customizing The Quick Access Toolbar

• The Quick Access Toolbar

Excel, In Previous Versions, let its fans move toolbars, rearrange buttons, and even scramble the order of items in the main menu. Reckless customizers could transform Excel so completely that no one else would be able to use their computers, and the instructions in books like this one would be useless.

Excel 2007 clamps down on customization. Unless you’re willing to get your hands dirty with a serious programming language, the ribbon is off limits. Instead, Excel lets you customize one tiny portion of screen real estate—the Quick Access toolbar.

This limitation might sound like a major one, but it’s actually a reasonable compromise. People who love to tweak and refine their workplaces (you know who you are) get to add all the timesaving shortcuts they need. Everyone else can relax. No matter what computer you’re working on, the ribbon is always there, with its comforting sameness and carefully organized tabs.

The Quick Access Toolbar

You’ve already seen the Quick Access toolbar (known to Excel nerds as the QAT). It’s the micro-size toolbar that sits above the ribbon. The Quick Access toolbar has only icons, but you can hover over a button to get the full command text.

When you first start out with Excel, the Quick Access toolbar is a lonely place, with buttons for quickly saving your workbook and undoing or redoing the last action. However, Excel gives you complete control over this space, including the ability ...