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