You’ve finished putting together your long Excel worksheet and realize that the page breaks are not inserted where you would like them, what do you do? By following these steps, you can easily move the page breaks to better meet your needs.
1. Select the View tab from the Ribbon.
2. Select Page Break Preview.
3. You will then see the pages of your worksheet, separated by blue lines. The blue lines represent the page breaks.
4. Click and drag the blue lines to where you want the page breaks.
When you are done, click the Office Button, click the arrow next to Print and select Print Preview to ensure your results are to your liking.
