Print Preview

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org,

Menu command Type What happens next?
Print Preview  

Previews the page as it would be printed. Also gives the option to change various settings graphically, such as margins, etc.

You can also invoke the page setup dialog from here, although many settings are not available such as 'rows to repeat at top, etc. Rows and columns can also be sized from print preview. although it should be noted that this view is sometimes not totally WYSIWYG (What You See Is What You Get) as Excel is trying to represent, using printer driver settings a view of the page on the screen that is totally different to representing it on paper. It is seldom far off, but allowance should be made.

VBA Sub SheetPrintPreview()
Dim mySheet As Worksheet
Set mySheet = ActiveSheet
'Preview the printout
mySheet.PrintPreview
End Sub

Top

Copyright Nick Hodge 2009. All Rights Reserved.