Previewing Before Print
There is an Excel file that teaches how to perform the Previewing Before Print operation.
Excel Spreadsheet for Previewing Before Print
This workbook demonstrates previewing before print using VBA macros on a 11-row data layout.
Hope it is useful.