• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9. Printing in Excel > Using Print Preview

Using Print Preview

With the worksheet you want to print open on your desktop, click the Print Preview button on the Standard toolbar.

The Print Preview window opens, displaying the worksheet in Print Preview mode. Click the Next button to move to the next page in the worksheet.

INTRODUCTION

Worksheets with lots of data can generate large print jobs, possibly containing hundreds of pages. Waiting until all these pages are printed to verify that the information is printed correctly can cost a lot in both time and printing supplies. To help prevent printing mistakes, use Print Preview to ensure that all the necessary elements appear on the pages being printed.


TIP

Page Break Preview Button

Click Page Break Preview to see exactly what is selected to print (in the print area). If you haven't set the print area, see “Setting the Print Area.” If you were already in Page Break Preview view when you clicked the Print Preview button, the toolbar button will display Normal view instead, which will display your entire worksheet (regardless of whether you have set the print area).


Click the Zoom button to increase the viewable size of the worksheet in Print Preview mode. (Click Zoom again to return to the original page size.)

Click Margins to toggle between displaying the margin indicators, which you can drag to set more or less of your worksheet to print.

Click the Close button to return to the worksheet's Normal view.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint