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.

Click on Breaks.

 

What Do You See? The Break will be inserted above the row that you selected. The Break looks like a dashed 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...

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.5. Manipulate Page Setup options for worksheets: Breaks