

A Font Color button is added to the Quick Access Toolbar.Ħ Remove a button from the Quick Access Toolbar. But there's an easier way!ĥ Add a Font Color button to the Quick Access Toolbar.Ĭlick the Home tab on the ribbon (if it isn't already selected) and then right-click on the Font Color button at the bottom right of the Font Group.Ĭhoose the Add to Quick Access Toolbar item. This enables you to add any command in Excel to the toolbar. option is available when you click the Customize Quick Access Toolbar button.

You are now able to Print Preview your work with a single click of the mouse.Ĥ Add custom buttons to the Print Preview toolbar. A new button now appears on the Quick Access Toolbar. To do this click the Customize Quick Access Toolbar button (see sidebar) and then click on the Print Preview item in the drop-down list. Wouldn't it be better if you could show a print preview with just one click? Every time you use it, however, it is going to take three clicks of the mouse. Print Preview is a very useful feature and you'll probably use it a lot. When you've finished playing with the Print Preview click the Close Print Preview button to return to the workbook.ģ Add a Print Preview button to the Quick Access Toolbar. You can click the Next Page and Previous Page buttons to move through the print preview and use the Zoom button to magnify the page for a clearer view. Notice that the ribbon now displays a contextual menu because there are only a few options open to you when previewing. Click Office à Print à Preview:Ī preview of the how the page will print is displayed. Open the Wealth of Nations sample worksheet.Ģ Preview how the Life Expectancy worksheet will look when printed.Ĭlick the Life Expectancy tab at the bottom of the worksheet to open the Life Expectancy worksheet. This lesson will introduce you to the main features. The Quick Access Toolbar is one of the keys to being really productive with Excel 2007.

In this lesson we'll add some useful buttons to the Quick Access Toolbar to save a few clicks. In Excel 2007 you may have just one custom toolbar: the Quick Access Toolbar.
#LEARNING EXCEL 2007 TUTORIAL FREE#
This lesson (along with 31 more) is available free of charge from my site at.
