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

Chapter 5. Printing Worksheets > Mastering Excel's Page Break Features

Mastering Excel's Page Break Features

When you print a worksheet, Excel breaks up the pages based on the margins you have selected, the column width, the scaling options, and other page setup selections. Excel also automatically inserts page breaks when you define a print area. Page breaks appear as dashed lines on the worksheet. They aren't always easy to see, unless you're in Preview mode or if you have Excel's gridlines turned off (to do so, choose Tools, Options, display the General tab, and deselect the Gridlines check box).

With Excel, you can insert two types of page breaks: vertical and horizontal. A vertical page break will break the print range at the current column. A horizontal page break will break the print range at the current row.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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