|
| |
|
Print Preview
in Excel
By Laura
Noble
|
|
 |
|
|
|
Opening Print Preview before printing a
spreadsheet is helpful as it displays where page breaks exist. Often the
furthest right column(s) may print on a separate page and changing to Print
Preview will show you this.
|
|
Print Preview Icon |
Print
Preview: Open Print Preview dialog by clicking the Print
Preview icon or within the Print dialog box clicking the Preview button
as described in article on
Printing.
Mouse Pointer will change to a magnifying glass as mouse
is moved over preview. Mouse click once and the view will enlarge, click
again and view will return to original view.
 |
To view Next or Previous page click the
appropriate button on the toolbar.
|
 |
To check the total number of pages of the current print
selection, look in the bottom left hand corner of box.
|
 |
To view exact locations of page breaks, click the Page
Break Preview button. To return to normal view, select from
the View menu, Normal (refer to article on
Page Break Preview
for more information
).
|
 |
To Print
from Print Preview, click the
appropriate button on the toolbar.
|
 |
To change page setup, click the Setup
button on
the toolbar.
|
 |
To return to normal view and make revisions, click the Close button
on the toolbar (second to last button).
|


Refer to article on
Printing for information on how to
print a selection vs an entire workbook.
Refer to article on
Page Break Preview to learn about viewing where actual page breaks
occur in a spreadsheet.
Printer Friendly Version

Previously published in
Networking Today, November 2001.
|
|