NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Print Preview in Excel

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.

Click to open Print Version of Printing

Refer to article on Page Break Preview to learn about viewing where actual page breaks occur in a spreadsheet.

Click to open Print Version of Page Break Preview

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer