Where Excel puts page breaks and why you might want to move them

Excel automatically breaks your spreadsheet into pages based on the paper size you have selected and the margins you set. When you print, Excel draws an invisible line after a certain number of rows and columns, then starts a fresh page. Most of the time this happens where you do not want it — cutting a table in half, or leaving a single column stranded on its own page.

You can move these breaks manually so your printed pages break at sensible places: after a complete section of data, or before a column that belongs with the previous one. Excel gives you two ways to do this: you can drag the breaks directly on screen, or you can insert breaks at exact row and column positions you choose.

Key Takeaways

  • Excel shows page breaks as blue dotted lines when you switch to Page Break Preview view, and you can drag these lines to new positions with your mouse.
  • Dragging a page break moves it to the row or column you drag it to, so the page will end just before that row or column starts.
  • You can also insert a manual page break at a specific row or column by clicking there and using the Insert menu, which overrides Excel's automatic breaks.
  • To remove a page break you added, right-click the break line and choose Delete Page Break, or select the row or column and use the Insert menu to remove it.
  • Resetting all your changes at once is faster than removing them one by one — use the Page Layout tab and choose Reset All Page Breaks.

Switching to Page Break Preview to see where pages will split

Before you move anything, you need to see where Excel is currently breaking pages. The normal view does not show these breaks. Switch to Page Break Preview by clicking the View tab at the top of the ribbon, then clicking the Page Break Preview button.

Excel will redraw your spreadsheet and show blue dotted lines running horizontally and vertically across it. The horizontal lines show where rows will split between pages. The vertical lines show where columns will split. The areas between the lines are the actual pages that will print. White areas will print; gray areas will not.

Once you are in this view, you can see exactly which rows and columns land on which pages. If a table you want to keep together is split by a blue line, that is what you will fix next.

Dragging page breaks to new positions

To move a page break, position your mouse directly on the blue dotted line you want to move. Your cursor will change to a resize cursor (a double-headed arrow). Click and drag the line to the new position where you want the page to break.

If you are moving a horizontal break (a row break), drag it up or down. The page will now end at the row just before where you dragged the line. For example, if you drag the break line to row 50, the page will end at row 49, and row 50 will start on the next page.

If you are moving a vertical break (a column break), drag it left or right. The page will end at the column just before the line. Release the mouse when the line is where you want it. The gray area will shift to show you the new page boundaries.

You can move as many breaks as you need. Each one you drag creates a manual break that overrides Excel's automatic calculation. If you later change the data or margins, your manual breaks stay in place unless you remove them.

Inserting a page break at a specific row or column

If you prefer to set breaks by clicking rather than dragging, you can insert them directly. Click on the row number or column letter where you want the break to start. For a row break, click the row number on the left side. For a column break, click the column letter at the top.

Once you have selected the row or column, go to the Page Layout tab on the ribbon. Click the Breaks button (it shows a page with a line through it). A menu will open with options including Insert Page Break. Click it.

Excel will insert a page break just before the row or column you selected. A blue line will appear on the left side of that row or above that column. The page will now end just before this row or column starts, and everything from that point onward will be on the next page.

Removing page breaks you no longer want

If you added a page break and later decide you do not want it, you can delete it. The fastest way is to right-click directly on the blue dotted line of the break you want to remove. A menu will appear with the option Delete Page Break. Click it, and the line disappears.

Alternatively, you can click on the row or column where the break is located, go to the Page Layout tab, click Breaks, and select Delete Page Break. This removes the break at that location.

If you have added many manual breaks and want to start over, you can remove them all at once. Go to the Page Layout tab, click Breaks, and select Reset All Page Breaks. Excel will delete every manual break you added and return to its automatic page breaks based on your paper size and margins.

Switching back to normal view after you finish

Once you have positioned your page breaks the way you want them, you can switch back to the normal spreadsheet view. Click the View tab and select Normal. The blue dotted lines will disappear, but your page breaks remain in place.

The next time you print or open the Print Preview, you will see your spreadsheet broken at the positions you set. If you need to adjust the breaks again later, straightforward switch back to Page Break Preview, move the lines, and switch back to Normal view.

Checking your page breaks before you print

Before you send your spreadsheet to the printer, it is worth checking how it will actually look on paper. Press Ctrl+P (or Cmd+P on Mac) to open the Print dialog. Most print dialogs show a preview of what will print on the first page. Scroll through the preview to see how your data breaks across pages.

If a page break is still in the wrong place, close the print dialog, go back to Page Break Preview, adjust the break, and check the preview again. This takes a few seconds and saves you from printing pages that do not look the way you intended.

Frequently Asked Questions

Can I move a page break to the middle of a row or column?

No. Page breaks always happen at the edge of a complete row or column. You cannot break a single cell in half. If you need to split data more finely, you may need to reorganize your spreadsheet by moving rows or columns around.

What happens to my page breaks if I add or delete rows?

Manual page breaks stay attached to the row or column they were set at. If you insert new rows above a break, the break moves down with the data. If you delete rows, the break may move up. If you delete the row the break is on, the break is removed.

Why does my page break keep moving back to where it was?

If you have set a very narrow margin or a very small paper size, Excel may force the break back to its automatic position because your manual break would create a page with no content. Try increasing your margins or changing your paper size, then adjust the break again.

Can I set different page breaks for different sheets in the same workbook?

Yes. Each sheet in your workbook has its own page breaks. Switch to the sheet you want to adjust, go to Page Break Preview, set the breaks for that sheet, then switch to the next sheet and repeat. Your settings do not affect other sheets.

How do I print only certain pages of my spreadsheet?

Open the Print dialog and look for a field labeled "Pages" or "Print Range." You can type the page numbers you want to print, such as "1-3" or "2,4,6". This prints only those pages, regardless of where your page breaks are set.