Page breaks divide worksheets into separate pages when you print. In Page Break Preview, you can insert, move, or remove page breaks in a worksheet.
- Select View > Page Break Preview.
In Page Break Preview, dashed lines are page breaks that Excel automatically adds. Solid lines are breaks that you add manually.
Tip
If you don't want to change the page breaks, use Print Preview (File > Print) to see what the printed pages will look like.