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

Inserting Page Breaks

If you want to print a worksheet that is larger than one page, Excel divides it into pages by inserting automatic page breaks. These page breaks are based on paper size, margin settings, and scaling options you set. You can change which rows or columns are printed on the page by inserting horizontal or vertical page breaks. In page break preview, you can view the page breaks and move them by dragging them to a different location on the worksheet.

Insert a Page Break

To insert a horizontal page break, click the row where you want to insert a page break.

To insert a vertical page break, click the column where you want to insert a page break.

Click the Insert menu, and then click Page Break.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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