Page Layout -> Page Setup ->Breaks

Page Setup: Breaks

There are two ways to change the Page Breaks. Here are the options on the Page Layout Ribbon.

 

5. Try This: Add a Break

Select Row 19 in the sample spreadsheet.

Go to Page Layout -> Page Setup->Breaks.

Click on Insert Page Break.

 

What Do You See? The Break will be inserted above the row that you selected. The Break looks like a solid line.

 

What Else Do You See? You can use the same menu to Remove Page Breaks or Reset All Page Breaks.

 

Keep going, there are more Page Setup options to consider...

graphic2

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.3 Format Worksheets and Workbooks: Modify Page Setup (Breaks)

graphic1
 
graphic3