Frequently Asked Questions

When a spreadsheet is printed or previewed for the first time, Excel defines the print area and determines page breaks as necessary. A page break occurs when data cannot fit on one page. These automatic page breaks appear as dashed lines in the worksheet. If the pages are not separated at the location you desire, then you can insert both vertical and horizontal manual page breaks. Excel provides a Page Break Preview for managing page breaks.

Select View tab, and click on the Page Break Preview button.

The Page Break Preview window will appear. Thick blue lines indicate Page breaks and page numbers are illustrated by watermark gray text.

To move the page break to your desired location, position the mouse pointer on the blue line, hold the right mouse button down, and then drag to the desired location.

To return to the normal spreadsheet view.
click on the Normal button, located on the View ribbon.