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 Method 1 of 2:

Moving Page Breaks

Step 1 Open your spreadsheet in Excel or create a new file.

Fair Use (screenshot)
\n">

Step 2 Enter Page Break Preview view.

Fair Use (screenshot)
\n"> Advertisement

Step 3 Navigate to your page break.

Fair Use (screenshot)
\n">

Step 4 Hover your cursor over the page break.

Fair Use (screenshot)
\n">

Step 5 Drag and drop the page break to where you want it.

Fair Use (screenshot)
\n"> Advertisement Method 2 of 2:

Deleting Page Breaks

Step 1 Open your spreadsheet in Excel or create a new document.

Fair Use (screenshot)
\n">

Step 2 Enter Page Break Preview view.

Fair Use (screenshot)
\n">

Step 3 Navigate to the column to the right (vertical page break) or below (horizontal) your page break.

Fair Use (screenshot)
\n">

<a href=Step 4 Click the Page Layout tab." width="460" height="347" />

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

Step 5 Click Breaks.

Fair Use (screenshot)
\n">

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

Step 6 Click Remove Page Break.

Fair Use (screenshot)
\n"> Advertisement

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

You Might Also Like

Merge Cells in Excel

How to Merge Cells in Microsoft Excel: A Quick Guide

Password Protect an Excel Spreadsheet

How to Password Protect a Microsoft Excel Spreadsheet

Use If‐Else in Excel

How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial

Unprotect an Excel Sheet

Unprotect an Excel Sheet

Link Sheets in Excel

Link Sheets in Excel

Create a Mortgage Calculator With Microsoft Excel

Create a Mortgage Calculator With Microsoft Excel

Insert Pictures in Excel That Automatically Size to Fit Cells

Insert Pictures in Excel That Automatically Size to Fit Cells

Make a Spreadsheet in Excel

Make a Spreadsheet in Excel

Recover a Corrupt Excel File

Recover a Corrupt Excel File

Unhide Columns in Excel

How to Show Hidden Columns in Microsoft Excel & Unhide Column A

Insert Rows in Excel

How to Insert and Delete Rows in Microsoft Excel: Quick Guide

Add Links in Excel

4 Easy Ways to Add Links in Microsoft Excel

Ethernet Doesn

How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows

Create an Inventory List in Excel

How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide