Unlike Microsoft Word, which visually separates your document into standard 8.5 x 11-inch pages right on the screen, Microsoft Excel presents you with an infinite, borderless grid. This makes data entry easy, but it makes printing incredibly difficult. If you simply press “Print” on a large spreadsheet, Excel will aggressively chop your data into awkward pieces, often leaving one crucial column of numbers orphaned on a page all by itself.
To control exactly how your data is distributed across physical pieces of paper, you must take manual control of the pagination by inserting your own Page Breaks.
This guide explains how to manually insert, view, and remove page breaks in Microsoft Excel to ensure your spreadsheets print perfectly every time.
Step 1: Switch to Page Break Preview Mode
Before you start adding breaks, you need to see how Excel is currently planning to butcher your document. You cannot see this clearly in the standard grid view.
- Click the View tab on the main ribbon at the top of the screen.
- On the far left side of the ribbon, click the button labeled Page Break Preview.
Your screen will change dramatically. Your data will be highlighted in white, and the empty cells will turn dark gray. You will see thick blue lines overlaid on your data, along with large watermark text that says “Page 1”, “Page 2”, etc. The solid blue lines represent the outer borders of your print area, and the dashed blue lines represent the automatic page breaks that Excel has calculated.
Step 2: Insert a Manual Page Break
Let’s assume Excel’s dashed blue line splits your “Q2 Sales” table directly in half, printing April and May on Page 1, but pushing June to Page 2. You want the entire table to start fresh on Page 2.
- Select the Row where you want the new page to begin. (Click the physical row number on the far left side of the screen, e.g., click the number ’25’ so the entire row highlights).
- Click the Page Layout tab on the top ribbon.
- Look for the “Page Setup” group and click the Breaks button.
- From the drop-down menu, select Insert Page Break.
A solid blue line will instantly appear directly above the row you selected. This solid line indicates a manual page break that you control, overriding Excel’s automatic dashed lines.
Note: If you need to force a vertical page break (e.g., separating columns instead of rows), you would highlight a Column letter instead of a Row number, and the break will be inserted immediately to the left of your selection.
Step 3: Remove or Adjust Page Breaks
Manual page breaks are stubborn. If you add 50 new rows of data above your manual break, the break will not move down; it will stay anchored exactly where you put it, potentially ruining your layout.
To move a break: While in Page Break Preview mode, simply hover your mouse over the solid blue line until your cursor turns into a double-sided arrow. Click and drag the line up or down to a new location.
To delete a single break: Highlight the row immediately below the solid blue line. Go back to Page Layout > Breaks, and select Remove Page Break.
To delete all manual breaks: If your spreadsheet has become a chaotic mess of manual formatting, you can reset everything to the default settings by clicking Page Layout > Breaks > Reset All Page Breaks. Excel will delete your manual solid lines and replace them with its automatic dashed lines based on standard paper sizes.