Create manual page breaks in a worksheet with Excel 2016 for Mac

When you print, page breaks appear automatically where content on a sheet "breaks" or continues to the next page. In normal view, they appear as dashed horizontal and vertical lines; in page layout view, they appear as empty spaces between the pages. You can adjust where automatic page breaks occur and add your own page breaks manually. You can also remove manual page breaks, but you can't remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.

Page breaks as displayed in normal view

Page breaks

View page breaks

After you open the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.

  1. Press COMMAND P, or on the File menu, click Print.

    In the Print dialog box, you can view a quick preview of how the pages will print.

  2. Click Cancel to close the Print dialog box.

    Dashed blue lines appear on the sheet.

    Note: To hide the dashed blue lines from sight, click Excel, click Preferences, click View, and then under Show in Workbook, clear the Page breaks check box.

Insert a horizontal or vertical manual page break

  1. Do one of the following:

    To insert a

    Do this

    Horizontal page break

    Select the row that is underneath the row where you want the page to break.

    Vertical page break

    Select the column that is to the right of the column where you want the page to break.

  2. On the Page Layout tab, under click Breaks, and then click Insert Page Break.

    On the Page Layout tab, select Breaks

Move a page break

  1. On the View tab, click Normal.

  2. Rest the pointer on the page break line until the pointer changes to a Horizontal page break handle , and then drag the page break line to a new location.

    Note: When you move an automatic page break, it changes to a manual page break. Manual page breaks are not adjusted automatically.

Remove a manual page break

  1. Do one of the following:

    To remove a

    Do this

    Horizontal page break

    Select the row below the page break.

    Vertical page break

    Select the column to the right of the page break.

  2. On the Page Layout tab, click Breaks, and then click Remove Page Break.

    On the Page Layout tab, select Breaks

Remove all manual page breaks

  • On the Page Layout tab, click Breaks, and then click Reset All Page Breaks.

    On the Page Layout tab, select Breaks

See Also

Scale the sheet size for printing in Excel 2016 for Mac

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×