Download ArticleLearn how to change where the page breaks go in your Excel spreadsheet
Download ArticleX
This article was co-authored by How.com.vn staff writer, Hannah Dillon. Hannah Dillon is a Technology Writer and Editor at How.com.vn. 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 How.com.vn.
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 48,860 times.
Learn more...
This How.com.vn 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."
Steps
Open your spreadsheet in Excel or create a new file. You can either open the saved spreadsheet within Excel by clicking File > Open, or you can right-click the file in your file explorer.- You can adjust the page breaks with any desktop program of Excel. You cannot use a mobile phone or tablet or the web version.
Enter Page Break Preview view. To do this, click the View tab and select Page Break Preview. The view will change to show the pages that will print. Empty cells that will not be printed will not display. You'll see all the page breaks in blue.[1]- Solid lines indicate manually added page breaks. Dashed lines indicate page breaks that Excel added automatically.[2]
Advertisement
Navigate to your page break. If you haven't inserted a page break, you can read more about the feature in How to Insert a Page Break in an Excel Worksheet.- 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.
Hover your cursor over the page break. Your cursor will change to a two-sided arrow to indicate you can move the page break.[3]- You can move manual or automatically added page breaks.
Drag and drop the page break to where you want it. When the cursor changes to the two-sided arrow, you can drag and drop the page break.- 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]
Advertisement
Open your spreadsheet in Excel or create a new document. You can open the spreadsheet within Excel by clicking File > Open, or you can right-click the file in your file explorer.- 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).
Enter Page Break Preview view. To do this, click the View tab and select Page Break Preview. The view will change to show the pages that will print. Empty cells that will not be printed will not display. You'll see all the page breaks in blue.
Navigate to the column to the right (vertical page break) or below (horizontal) your page break. If you haven't inserted a page break, you can read more about the feature in How to Insert a Page Break in an Excel Worksheet.- 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.
Click the Page Layout tab. You'll most likely find this in the editing ribbon above your workspace.
Click Breaks. This icon looks like the break between two printed pages in the "Page Setup" grouping.
Click Remove Page Break. This is usually the last option in the menu. The page break will be removed.- You can also drag-and-drop the page break outside the Page Break Preview view.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
SubmitAdvertisement
How.com.vn Video: How to Adjust Page Breaks in Excel
Watch
Tips
- 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.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
Advertisement
References
- ↑ https://youtu.be/UsZsLfAX1qM?t=174
- ↑ https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2#ID0EAACAAA=Windows
- ↑ https://youtu.be/UsZsLfAX1qM?t=208
- ↑ https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2#ID0EAACAAA=Windows
- ↑ https://youtu.be/UsZsLfAX1qM?t=174
- ↑ https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2#ID0EAACAAA=Windows
About This Article
How.com.vn Technology Writer
This article was co-authored by How.com.vn staff writer, Hannah Dillon. Hannah Dillon is a Technology Writer and Editor at How.com.vn. 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 How.com.vn. This article has been viewed 48,860 times.
How helpful is this?
Co-authors: 4
Updated: February 14, 2024
Views: 48,860
Categories: Microsoft Excel
Article SummaryX
1. Open your spreadsheet in Excel or create a new file.
2. Enter Page Break Preview view.
3. Navigate to your page break.
4. Hover your cursor over the page break.
5. Drag and drop the page break to where you want it.
Did this summary help you?
Thanks to all authors for creating a page that has been read 48,860 times.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
Advertisement
