Page Break Preview

Microsoft Excel 2010

In Page Break Preview you can view the location of the page breaks and move them, as desired. 

As you widen or lengthen a page break (for the purpose of fitting more information on a page), Excel will shrink your data proportionately.

  1. Display the View ribbon and click on the Page Break Preview button (within the Workbook views area of the ribbon). Your document will be displayed with dashed lines indicating the page breaks. Example:
  2. If the message shown above appears, you can choose Do not show this dialog again before choosing OK.

  3. Drag a vertical or horizontal border to move a page break.

To return to normal view, select Normal from the View ribbon.

Additional References