Excel Tip: Overriding and Removing Page Breaks

Share this content

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.

About admin


Please login or register to join the discussion.

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)