Previewing Pages in Excel 2007 with Print Preview
Save wasted paper and your sanity by using the Print Preview feature in Excel 2007 before you print any worksheet, section of worksheet, or entire workbook. You can use Print Preview to see exactly how the worksheet data will be paged when printed and to make last-minute changes to the page settings before sending the report to the printer.
1
Click the Office Button and then point to the arrow beside the Print option.
The Print options appear in the right pane of the Office button menu.
2
Click the Print Preview command.
Excel displays the first page of the report with its own Print Preview contextual tab. Notice that you can barely read its contents. When positioned over the worksheet, the mouse pointer becomes a magnifying glass.
3
Click the Zoom button on the Print Preview tab (or click the previewed page with the magnifying glass pointer).
The previewed worksheet displays at 100% zoom so you can see the details. After you enlarge a page to actual size, you can use the scroll bars or the arrow keys to bring new parts of the page into view in the Print Preview window.
4
To return to the full-page view, click the mouse pointer on the page or click the Zoom command button on the Print Preview tab.
Excel indicates the number of pages in a report on the Status bar of the Print Preview window. If your report has more than one page, view pages that follow by clicking the Next Page button in the Preview group of the Print Preview tab. To review a page you’ve already seen, click the Previous Page button.
5
Click the Close Print Preview button to return to the previous view.
You can also choose to modify the page setup or print directly from the Print Preview tab by using the buttons in the Print group.
If you use Print Preview frequently, you can add a Print Preview button to the Quick Access toolbar. Click the Customize Quick Access Toolbar button and then click Print Preview on its drop-down menu. (To remove the button, you simply click the Print Preview option on this drop-down menu a second time.)

Excel Glossary
active cell
The worksheet cell that contains the cell cursor. Each worksheet can have only one active cell.

Excel Glossary
AutoComplete
A feature that looks at the entries that you make in a worksheet column and automatically duplicates them in subsequent rows whenever you start a new entry that begins with the same letter or letters as an existing entry in that column.

Excel Glossary
AutoCorrect
A feature that alerts Excel 2007 to common typing errors and your own typing errors (that you specify) and tells the program how it should automatically fix them for you.

Excel Glossary
AutoFill
An Excel 2007 feature that quickly creates a series of entries based on the data you enter in one or two cells. AutoFill works with days of the week, months of the year, yearly quarters; consecutive series of numbers; and formulas. You also can add your own custom AutoFill series.

Excel Glossary
cell
The intersection of a column and row in the worksheet.

Excel Glossary
cell address
The cell identifier, determined by its column letter(s) followed by the row number, as in cell A1, the very first cell of each worksheet at the intersection of column A and row 1.

Excel Glossary
cell cursor
The black border that surrounds the active cell in a worksheet.

Excel Glossary
clip art
Readymade drawings, illustrations, and photos offered by Microsoft for use in Microsoft Office applications.

Excel Glossary
Compatibility Checker
A utility in Excel 2007 that you use to find potential compatibility issues if you plan to save an Excel 2007 workbook file in the older Excel 97–2003 file format.

Excel Glossary
current cell
The worksheet cell that contains the cell cursor. Each worksheet can have only one current cell.

Excel Glossary
data table
A range of cells in a worksheet in which you enter a series of possible values that Excel plugs into a formula so you can perform what-if analysis on the data.

Excel Glossary
dialog box
A rectangular window with settings and commands that appears when you click a dialog box launcher or certain other commands on the Ribbon.

Excel Glossary
dialog box launcher
A small icon in the lower-right corner of a group of command buttons on the Ribbon that you click to access a dialog box with additional related settings and commands.

Excel Glossary
function
A part of a formula that takes a number of specific arguments and then returns a single value based on those arguments.

Excel Glossary
gallery
A drop-down list of thumbnail selections that appears when you click certain command buttons on the Ribbon.

Excel Glossary
group
A section of a tab on the Excel 2007 Ribbon that organizes related command buttons into subtasks normally performed as part of the tab’s larger core task. The name of a group appears at the bottom of the group, such as the Font group on the Home tab.

Excel Glossary
hyperlink
Specially formatted text that anyone can click to jump to Web sites, move to other cells or workbooks, or create an e-mail message.

Excel Glossary
keyboard shortcuts
A combination of keys that you can press to execute certain commands, as opposed to finding and clicking the commands' buttons on the Ribbon or elsewhere.

Excel Glossary
Live Preview
A feature in Excel 2007 that enables you to point to thumbnails on a drop-down gallery to see how a new font, font size, table style, or cell style would look on your selected data before you actually apply it.

Excel Glossary
Name box
The left-most section of the Formula bar that displays the address or name of the current cell.

Excel Glossary
PDF (Portable Document File)
File format developed by Adobe Systems Incorporated that enables people to open and print documents without access to the original programs with which the documents were created.

Excel Glossary
pivot table
A special type of table unique to Excel 2007 that enables you to summarize large amounts of data and pivot or rearrange the table's data to display different summaries of the information it contains.

Excel Glossary
Ribbon
A new feature of the Excel 2007 interface that replaces the menus and toolbars of previous versions; appears at the top of the Excel window, just below the title bar.

Excel Glossary
ScreenTip
A small window that displays descriptive text when you point to but don't click a command on the Ribbon or other objects in a worksheet.

Excel Glossary
sheet tabs
Small tabs near the bottom of a worksheet that you click to move between the worksheets in a workbook. You can assign descriptive names to sheet tabs.

Excel Glossary
SmartArt
A type of graphic object in Excel 2007 that gives you the ability to quickly and easily construct graphical lists and diagrams in the worksheet.

Excel Glossary
Status bar
A horizontal bar that appears at the bottom of the Excel 2007 window and keeps you informed of Excel’s current mode. In addition, you can use the Status bar to select a new worksheet view and to zoom in and out on the worksheet.

Excel Glossary
tabs
The various "pages" of Excel 2007's Ribbon interface that you click to display command buttons relating to the tab's name, such as Page Layout and Formulas.

Excel Glossary
template
A pre-designed worksheet that can be used as a basis for creating new worksheets.

Excel Glossary
WordArt
Stylized text objects that you use to add pizzazz and emphasis to headings and other text in Excel 2007 worksheets.

Excel Glossary
workbook
The basic file type that you create when you use Excel 2007. A new workbook consists of three worksheets by default.

Excel Glossary
worksheet
The main document that you work in when you enter data into cells within Excel 2007. A worksheet is stored in a workbook file.

Excel Glossary
Worksheet area
The portion of an Excel 2007 worksheet in which you enter cell data and add objects such as charts and graphics.

Excel Glossary
Zoom slider
An object on the Status bar in Excel 2007 that enables you to increase the magnification in a worksheet or shrink it down to get an overall picture of the worksheet data.
Comments (5)
@Carol and James: I don't print much, and I rarely work with charts, but try this: Click the Office button and choose Excel Options. On the left, click Advanced. The third section down is "Print," and it has only one option: "High Quality Mode for Graphics." If that's on, turn it off; if it's off, turn it on. Then click OK.
Then try printing (and print preview) again and see if it makes a difference. This is probably a problem with dpi vs. ppi. Also check for graphics settings in your printer's control dialog box.
Leave a Reply