How to insert page break in excel

Answer

To insert a page break in Excel, go to the Page Layout tab, click Breaks in the Page Setup group, and select Insert Page Break. Excel will add a manual page break at the selected location to control how pages print.

Types of Page Breaks in Excel

Excel uses two types of page breaks:

Automatic Page Breaks

• Created by Excel based on paper size, margins, and scaling

• Displayed as dashed lines

Manual Page Breaks

• Inserted by the user

• Displayed as solid lines

Inserting Horizontal Page Breaks

1. Select the row where the new page should begin

2. Go to Page Layout

3. Click Breaks

4. Select Insert Page Break

The horizontal break appears above the selected row.

Inserting Vertical Page Breaks

1. Select the column where the new page should begin

2. Go to Page Layout

3. Click Breaks

4. Choose Insert Page Break

The vertical break appears to the left of the selected column.

Inserting Both Horizontal and Vertical Page Breaks

1. Click a cell below and to the right of where both breaks should appear

2. Go to Page Layout

3. Click Breaks

4. Select Insert Page Break

Excel inserts a horizontal break above the cell and a vertical break to its left.

Using Page Break Preview Mode

Access through: View > Page Break Preview

In this mode:

• Blue dashed lines = automatic page breaks

• Blue solid lines = manual page breaks

• Breaks can be dragged to reposition them

• Page numbers appear visually

Keyboard Shortcuts for Page Breaks

Windows

• Alt + P + B + I — Inserts a manual page break

Mac

• No default shortcut

• Add Breaks to the Quick Access Toolbar for faster use

Removing Page Breaks

Remove a specific page break:

1. Select a cell below a horizontal break or right of a vertical break

2. Go to Page Layout

3. Click Breaks

4. Select Remove Page Break

Remove all manual breaks:

• Page Layout > Breaks > Reset All Page Breaks

Page Break Options in Print Settings

Access via File > Print > Page Setup

• Sheet tab: Show/hide page break indicators

• Margins tab: Center content horizontally or vertically between breaks

Managing Page Breaks for Large Data Sets

For large spreadsheets (10,000+ rows):

1. Set a print area first:
   Page Layout > Print Area > Set Print Area

2. Insert page breaks within the defined area for better control.

Troubleshooting Common Page Break Issues

Page breaks not showing

• Switch to Page Break Preview

• Enable: File > Options > Advanced > Show page breaks

Page breaks moving unexpectedly

• Check for hidden rows/columns

• Unhide everything before inserting breaks

Cannot insert page breaks

• Ensure the sheet is not protected

• Go to Review > Unprotect Sheet

Best Practices for Page Break Placement

• Insert breaks at logical data points (categories, months, sections)

• Keep related data on the same page

• Add breaks after subtotals, not inside grouped data

• Adjust margins to avoid pages with excessive white space

• Always preview using Print Preview (Ctrl + P / Cmd + P) before finalizing

Yes · 0 No · 0 Add Comment · 0

Add ·

Report