How to Move or Delete Page Breaks in Your Excel Documents: Guide

This article was co-authored by wikiHow staff writer, Hannah Dillon. Hannah Dillon is a Technology Writer and Editor at wikiHow. She graduated with a B.A. in Journalism from North Dakota State University in 2013 and has since worked in the video game industry as well as a few newspapers. From a young age Hannah has cultivated a love for writing and technology, and hopes to use these passions in tandem to help others in the articles she writes for wikiHow.

This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.

This article has been viewed 57,476 times.

This wikiHow will teach you how to manage and adjust page breaks in Excel using your computer. The mobile app does not have this functionality.

Things You Should Know

To preview your page breaks, click the "View" tab and select "Page Break Preview."
To move a page break, hover the cursor over it, then drag it to a new location.
To delete a page break, click the column to the right (or row below) the break, click "Page Layout," select "Breaks," then click "Remove Page Break."

Method 1 of 2:

Moving Page Breaks

Fair Use (screenshot)
\n">

You can adjust the page breaks with any desktop program of Excel. You cannot use a mobile phone or tablet or the web version.

Fair Use (screenshot)
\n">

Solid lines indicate manually added page breaks. Dashed lines indicate page breaks that Excel added automatically. [2] X Research source

your page break." width="460" height="344" />

Fair Use (screenshot)
\n">

To insert a page break, go to the place in the sheet you want to insert the page break, then go to the "Page Layout" tab and click "Breaks > Insert Page Break." You'll then see a thick line that indicates where the page break is.

Fair Use (screenshot)
\n">

You can move manual or automatically added page breaks.

Fair Use (screenshot)
\n">

You can drag-and-drop page breaks horizontally and vertically.
If this isn't working, you can check that drag-and-drop is enabled. To do that, go to File > Options. If you're using Excel 2007, click the Microsoft Office Button icon (in the top left corner of the program) > Excel Options. Go to the "Advanced" category and select Enable fill handle and cell drag-and-drop then click Ok. [4] X Research source

Advertisement Method 2 of 2:

Deleting Page Breaks

Fair Use (screenshot)
\n">

You can delete page breaks using any desktop program of Excel. You cannot use a mobile phone or tablet or the web version. Note that you cannot delete automatic page breaks (dashed lines), but you can move and change those into manual page breaks (solid lines).

Fair Use (screenshot)
\n">

Go to the "View" tab and click Page Break Preview. You'll see all the page breaks in blue. [5] X Research source
Solid lines indicate manually added page breaks. Dashed lines indicate page breaks that Excel added automatically. [6] X Research source

your page break." width="460" height="346" />

Fair Use (screenshot)
\n">

To insert a page break, go to the place in the sheet you want to insert the page break, then go to the "Page Layout" tab and click "Breaks > Insert Page Break." You'll then see a thick line that indicates where the page break is.

Fair Use (screenshot)
\n"> Click the Page Layout tab. You'll most likely find this in the editing ribbon above your workspace.

Fair Use (screenshot)
\n">

Click Breaks . This icon looks like the break between two printed pages in the "Page Setup" grouping.

Fair Use (screenshot)
\n">

You can also drag-and-drop the page break outside the Page Break Preview view.

Expert Q&A

Ask a Question 200 characters left Include your email address to get a message when this question is answered. Advertisement wikiHow Video: How to Adjust Page Breaks in Excel

When you move an automatic page break, the line will change from dashed to solid indicating that it has been adjusted from its automatic settings.

Submit a Tip All tip submissions are carefully reviewed before being published Please provide your name and last initial Thanks for submitting a tip for review! Advertisement