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

Part 9. Printing in Excel > Inserting Page Breaks

Inserting Page Breaks

Open the View menu and choose Page Break Preview to change to Page Break Preview mode.

Press the page up and page down keys on the keyboard to move through your worksheet in Page Break Preview. Notice that cells outside the print area are grayed out.

Open the File menu, choose Print Area, and select Clear Print Area to eliminate any current print area settings.

INTRODUCTION

When a worksheet page is filled to the margins with data, Excel automatically inserts a page break for you. There may be times, however, when you want to insert a page break manually. For example, if you are creating a report with multiple topic sections, you might want each topic to begin on a new page. Inserting a page break enables you to print each page separately, and the best way to insert page breaks is using Page Break Preview view (instead of Normal view).


TIP

Removing page breaks

To remove a page break, place the active cell so that one of the cell borders is touching the page break line. Then, open the Insert menu and choose Remove Page Break. (You can also do this in Normal view.)


Click the cell below and in the left-most column in which you want to insert a page break.

Open the Insert menu and choose Page Break to insert the page break.

The page break is inserted.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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