Appendix A. Customizing the Quick Access Toolbar

A. Customizing 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 estatethe 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.

Note: You can add a tab of your own to the ribbon. However, the process is definitely not easyin fact, it's aimed at experienced programmers who aren't intimidated by gnarly code. The standard for customizing the ribbon is called RibbonX, and it requires a blend of XML and a hard- core programming language like C#. Gearheads can get started with the introduction at

Excel 2007[c] The Missing Manual
Excel 2007[c] The Missing Manual
ISBN: 596527594
Year: 2007
Pages: 173 © 2008-2017.
If you may any questions please contact us: