There are often "better" places to stop printing on a page than others. If you have a multi-page document with headings for different sections, why let the printer print the heading for a section at the bottom of one page and the section on the following? You have some control over where Excel will break for a new page in printing. You have much more control than you think you will.
Consider
this a typical gradebook project and the instructor wants to print only
the names and final grade.
The Names column was copied to Column F, and the task is to get Excel to break the printing on the red line.
The first thing to do is to select the column where you want the page to break.
This is easily accomplished by clicking on the letter F above cell F1.
Then
you will insert a page break using the Menu and Insert + Page Break.
Excel will put a vertical dotted line indicating the printing will break pages around the line.
Breaking pages in a horizontal fashion has to be similar to breaking vertically.
First
select the row where you want the page to break.
This is accomplished by clicking on the row number (in this case 7).
Once you have selected the correct row, you would use the Menu and choose Insert + Page Break.
This will tell Excel to create a horizontal break which will be indicated to you with a horizontal dotted line.
If you can INSERT a page break, you should be able to change your mind. You might think the location of the remove Page Break is located under Edit, but it isn't!
First
select a cell adjacent to the page break line. Then you
would Insert a Remove Page Break. Select Insert + Remove Page Break
and the break you introduced will be removed.
Simple!