View -> Workbook Views ->Page Break Preview

Another Way to Edit the Breaks

The View Ribbon also has a Page Break preview. Let's compare the options.

 

Try This, Too: Page Break Preview

Go to View -> Workbook Views.

Click on Page Break Preview.

 

What Do You See? The Page Breaks are shown as thick, blue lines. Each page is identified by a watermark.

 

Did You Know...? You can reposition the Page Breaks by dragging the blue lines to a different Column or Row.

 

Please go to View -> Workbook Views.

Click on Normal to return to the default view for Microsoft Excel.

 

Keep going...

 

Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

4.2. Manipulate window views