Insert, move, or delete page breaks in a worksheet

To print a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) with the exact number of pages that you want, you can adjust the page breaks (page break: Divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert.) in the worksheet before you print it. Although you can work with page breaks in Normal view, we recommend that you use Page Break Preview view to adjust page breaks so that you can see how other changes that you make (such as page orientation and formatting changes) affect the automatic page breaks. For example, you can see how a change that you make to the row height and column width affects the placement of the automatic page breaks.

To adjust page breaks, you can insert your own page breaks, move existing page breaks, or delete any manually-inserted page breaks. You can also quickly reset all page breaks to automatic page breaks. After you finish working with page breaks, you can return to Normal view.

What do you want to do?


Learn more about page breaks

Page Break Preview view uses a different format to display each type of page break:

  • Dashed lines    A dashed line specifies an automatic page break.

Worksheet in Page Break Preview view showing automatic page breaks

  • Solid lines    A solid line specifies a manual page break.

Worksheet in Page Break Preview view showing manual page breaks

By default, page breaks are not shown in Normal view. However, if you want to view page breaks in Normal view, you can display them in this view.

In Normal view, you can use the Breaks command (Page Layout tab, Page Setup group) to insert, remove, and reset page breaks. You cannot drag page breaks to another location in Normal view.

Top of Page Top of Page

Insert a page break

  1. Click the worksheet that you want to print.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.

Excel Ribbon Image

 Tip   You can also click Page Break Preview Button image on the status bar.

  1. Do one of the following:
    • To insert a vertical page break, select the row below where you want to insert the page break.
    • To insert a horizontal page break, select the column to the right of where you want to insert the page break.
  2. On the Page Layout tab, in the Page Setup group, click Breaks.

Excel Ribbon Image

  1. Click Insert Page Break.

 Tip   You can also right-click the row or column below or to the right of where you want to insert the page break, and then click Insert Page Break.

 Note   If manual page breaks that you insert do not take effect, it may be that the Fit To scaling option has been selected on the Page tab of the Page Setup dialog box (Page Layout tab, Page Setup group, Dialog Box Launcher Button image ). To use the manual page breaks, change the scaling to Adjust to instead.

Top of Page Top of Page

Move a page break

 Important   To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.

  1. To verify that drag-and-drop is enabled, do the following:
  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
  1. Click the worksheet that you want to print.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.
    1. Excel Ribbon Image
    2.  Tip   You can also click Page Break Preview Button image on the status bar.

  3. To move a page break, drag the page break to a new location.

 Note   Moving an automatic page break changes it to a manual page break.

Top of Page Top of Page

Delete a page break

  1. Click the worksheet that you want to print.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.

Excel Ribbon Image

 Tip   You can also click Page Break Preview Button image on the status bar.

  1. Click the manual page break that you want to delete.

 Note   You cannot delete an automatic page break.

  1. On the Page Layout tab, in the Page Setup group, click Breaks.

Excel Ribbon Image

  1. Click Remove Page Break.

 Tip   You can also remove a page break by dragging it outside of the page break preview area (to the left past the row headers, or up past the column headers). If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. For more information, see Move an existing page break.

Top of Page Top of Page

Reset all page breaks

 Note   This removes all manual page breaks and resets the worksheet to display only the automatic page breaks.

  1. Click the worksheet that you want to print.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.

Excel Ribbon Image

 Tip   You can also click Page Break Preview Button image on the status bar.

  1. On the Page Layout tab, in the Page Setup group, click Breaks.

Excel Ribbon Image

  1. Click Reset All Page Breaks.

 Tip   You can also right-click any cell on the worksheet, and then click Reset All Page Breaks.

Top of Page Top of Page

Return to Normal view

  • To return to Normal view after you finish working with the page breaks, on the View tab, in the Workbook Views group, click Normal.

 Tip   You can also click Normal Button image on the status bar.

 Notes 

  • After working with page breaks in Page Break Preview view, you may still see the page breaks in Normal view because page breaks have been turned on automatically. To hide the page breaks, close and reopen the workbook without saving it.
  • Page breaks remain visible when you close and reopen the workbook after saving it. To turn them off, clear the Show page breaks check box in the Advanced category of the Excel Options dialog box. For more information, see Display or hide page breaks in Normal view.

Top of Page Top of Page

Display or hide page breaks in Normal view

  1. Click the Microsoft Office Button Button image, and then click Excel Options.
  1. In the Advanced category, under Display options for this worksheet, select or clear the Show page breaks check box to turn page breaks on or off in Normal view.

Top of Page Top of Page

 
 
Applies to:
Excel 2007