Dear Computer Lady,
I read your answers faithfully, and I hope you can help me learn how to get used to the new 2007 version of Excel. It seems like finding common commands is a lot harder than it used to be.
For example, printing my worksheet used to be one click, but now, I have to click at least three times before my worksheet is sent to the printer.
Do you have an easier way?
Allen in Georgia
I hear your frustration! I have found the 2007 versions of Word and Excel a lot harder to work in because all the commands are in different locations than they were in previous versions.
Microsoft has provided a way for us to put commonly used commands right at our fingertips in Excel 2007. It is called the Quick Access Toolbar.
You can add commands that you use frequently to the Quick Access Toolbar so that they are one click away. Here is how:
1. Open Excel 2007
2. Click the small down arrow to the right of the Quick Access Toolbar.
3. If the command you want to add is listed, just click on it to add to the toolbar.
4. If the command you want is not on the list, click on “More Commands” to use a more extensive list.
5. Select the command you want on the left, and click the “Add” button in the middle to add the command.
6. When you have added all the commands you want, click the “OK” button at the bottom of the window to close it and save your changes.
You can also add a command directly from the ribbon. For example, here is how to add the “Print Area” icon to the quick Access Toolbar:
1. Open Excel 2007
2. Click on the “Page Layout” tab
3. Right click on the “Print Area” icon.
4. In the context menu that appears, click on, “Add To Quick Access Toolbar”.
If you want to remove an icon from the Quick Access Toolbar, just right click on that icon, and in the context menu, click on “Remove from Quick Access Toolbar”.