Probably the most helpful customization for the Office 2007 products is to add buttons to the Quick Access toolbar. I like to use this for Printing, New Document, and in excel I have the Filter and Sort on my Quick Access toolbar. This just makes it a simple click instead of several clicks by going through the ribbon or the Office button.
The simplest way to do this is by clicking the small Down arrow to the right of the Quick Access toolbar and selecting a new button to add. But this is quite limited, because there are only a small number of commands you can add in this way.
Adding buttons to the Quick Access toolbar.
A better method is to click the Office Button, choose Word/Excel Options and then Customize. The screen shown here appears.
Choose a command from the left-hand side of the screen that you want to add to the Quick Access toolbar and click Add. You can change the order of the buttons by highlighting a button on the right side of the screen and using the Up and Down arrows to move it.
The list of commands you see on the left may seem
somewhat limited at first. That's because Word/Excel is showing you only the most
popular commands. There are plenty of others you can add.
Click the drop-down menu under "Choose commands
from" at the top of the screen, and you'll see other lists of commands -- All
Commands, Home Tab and so on. Select any option, and there will be plenty of
commands you can add.
Finally, there's an even easier way to add a
command. Right-click any object on the Ribbon and choose "Add to Quick Access
Toolbar." You can add not only individual commands in this way, but also entire
groups -- for example, the Font group.