Excel 2007: Move Page Breaks

Posted February 6, 2007 by Rob Rogers in Microsoft Excel

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.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.