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

Lesson 12. Printing Large Worksheets > Selecting a Print Area

Selecting a Print Area

You can tell Excel what part of the worksheet you want to print using the Print Area option. This option lets you single out an area as a separate page and then print that page. If the area is too large to fit on one page, Excel breaks it into multiple pages. If you do not select a print area, Excel prints either the entire worksheet or the entire workbook, depending on the options set in the Print dialog box.

To Include or Not to Include?

When deciding which cells to select for your print area, make sure you do not include the title, the subtitle, and the column and row headings in the print area. If you do, Excel may print the labels twice. Instead, print your titles and headings on each page of your printout by following the steps in the upcoming section, "Printing Column and Row Headings."



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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