Excel Tip: Overriding and Removing Page Breaks

istock_JohnnyLye_excel.jpg

istock_JohnnyLye_excel
istock_JohnnyLye_excel
Blogger
Share this content
1

Excel automatically determines where page breaks will occur, but you can create your own page breaks in your worksheets by forcing Excel to begin printing on a new page at the location that is best for you.

To create a horizontal page break, follow these steps:

  1. Place your cellpointer in Column A in the row below the row in which you wish to insert a page break.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

avatar
By Markus Schopenknecht
Jun 26th 2015 01:11

Funny. This is 10 years old, but i dont think much changed in the new versions of excel regarding the pagebreaks. In case somebody needs a step-by-step guide for excel 2010, http://www.excel-aid.com/excel-page-breakestablishing-page-breaks.htmlprovides that. Screenshots too, which i personally quite like. But again, its basically just about finding the page break preview button and then dragging a blue line around to adjust pagebreak.

Thanks (0)