What page breaks do in Excel

When you print a spreadsheet, Excel automatically breaks your data across multiple pages based on the paper size and margins you have set. A page break is the invisible line where one printed page ends and the next begins. By default, Excel places these breaks wherever the data runs out of room — usually in the middle of your data, which can split important information across pages or leave awkward blank space.

You can move these breaks manually to control exactly where your spreadsheet splits. This matters when you want to keep related rows or columns together, or when you need the printed output to match a specific layout for a report or presentation.

Key Takeaways

  • Excel shows page breaks as blue dashed lines in Page Break Preview mode, which is the easiest way to see and adjust them.
  • You can drag page break lines to new positions, or insert your own breaks before specific rows or columns to control the split.
  • Removing a manual break returns that section to automatic breaks, which recalculate based on your paper size and print settings.
  • Print Preview shows you exactly how the pages will look before you print, so you can verify the breaks are where you want them.

Switch to Page Break Preview to see the breaks

The easiest way to work with page breaks is to see them on your screen. Open your spreadsheet and look at the bottom right of the Excel window, where you will see three view buttons. Click the middle button labeled Page Break Preview. (In older versions of Excel, go to the View menu at the top and select Page Break Preview.)

Your spreadsheet will now show blue dashed lines running horizontally and vertically across your data. These lines mark where Excel will split the pages when you print. The areas outside these lines appear slightly grayed out — that is the margin space that will not print. The white areas inside the lines are what will actually appear on each page.

If you see a message asking whether you want to enter Page Break Preview, click Yes. You can return to the normal view anytime by clicking the first button at the bottom right (labeled Normal) or by going to View and selecting Normal.

Drag a page break line to move it

Once you can see the blue dashed lines, you can drag them to new positions. Move your mouse directly over a blue dashed line until the cursor changes to a resize arrow (it will point left and right for vertical lines, or up and down for horizontal lines). Then click and drag the line to where you want the page to break.

For example, if a horizontal blue line is splitting a table in half, you can drag it down to move the break below the entire table. If a vertical line is cutting through a group of related columns, drag it to the right to keep those columns together on one page. Release the mouse button when the line is in the position you want.

Excel will adjust the page layout when ready. If you drag a break too far and it creates a blank page, drag it back to a better position. There is no penalty for moving breaks around until you find the layout that works.

Insert a manual page break before a specific row or column

If you want to force a page break at an exact location, you can insert one manually. Click on the row number or column letter where you want the break to start. For example, if you want a new page to begin at row 50, click the number 50 on the left side of the spreadsheet.

Then go to the Insert menu at the top and select Page Break. Excel will insert a page break when ready before that row (or to the left of that column if you selected a column). A thicker blue line will appear, showing that this is a manual break you created, not an automatic one.

Manual breaks stay in place even if you add or remove data elsewhere in the spreadsheet, so use them when you need a break at a specific location that should not move.

Remove a page break you no longer need

If you have inserted a manual page break and later decide you do not want it, you can delete it. Click on the row or column when ready after the break line (the one where the break starts), then go to Insert and select Delete Page Break. The manual break will disappear, and that section will return to automatic page breaks based on your print settings.

You cannot delete automatic page breaks — they recalculate based on your paper size and margins. If you want to change where automatic breaks fall, you need to either drag them (as described above) or adjust your print settings like margins or paper orientation, which will cause Excel to recalculate all the breaks.

Check your page breaks in Print Preview before printing

Before you actually print, always check how your pages will look. Go to File at the top, then select Print. The right side of the screen will show a preview of your first page. Use the arrow buttons or page navigation at the bottom to scroll through each page and confirm the breaks are where you want them.

If you see a problem — a table split awkwardly, or a blank page you did not expect — close the Print dialog (press Escape or click the back arrow), go back to Page Break Preview, adjust the breaks, and check Print Preview again. This takes a minute but saves you from printing pages you will have to throw away.

Adjust margins and orientation if breaks are still not right

Sometimes moving individual breaks is not enough. If your data is just barely too wide or too tall for the page, changing the margins or rotating the page to landscape can fit more on each page and reduce the number of breaks you need.

Go to Page Layout (or Page Setup in older Excel versions) at the top menu, then select Margins. Choose a preset like Narrow, or click Custom Margins to set your own. Smaller margins mean more room for data on each page. You can also select Orientation and choose Landscape instead of Portrait to rotate the page sideways, which gives you more width.

After you change margins or orientation, return to Page Break Preview to see how the blue lines have moved. You may find that you need fewer manual adjustments, or that the automatic breaks now fall in better places.

Frequently Asked Questions

Why does Excel keep adding extra blank pages when I print?

This usually happens when a page break is set too far to the right or too far down, leaving a small sliver of data on an otherwise empty page. In Page Break Preview, look for blue lines that are creating tiny sections. Drag those lines to eliminate the blank pages, or delete manual breaks you no longer need and let Excel recalculate.

Can I set a page break to repeat certain rows on every page?

Yes, but that is a different feature called Print Titles. Go to Page Layout, select Print Titles, and specify which rows (usually headers) or columns you want to repeat. This keeps your column headers visible on every printed page without creating extra page breaks.

What happens to my page breaks if I add more data to the spreadsheet?

Automatic page breaks recalculate when you add data, so they may move. Manual page breaks you inserted stay in place. If a manual break no longer makes sense after you add data, you can delete it and let automatic breaks take over, or move it to a new location.

How do I get back to normal view after using Page Break Preview?

Click the Normal button at the bottom right of the Excel window, or go to View and select Normal. Your page breaks remain in place — you just will not see the blue dashed lines anymore. You can return to Page Break Preview anytime to adjust them further.