HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Move Page Breaks

Excel 2007: Move Page Breaks

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.

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


Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android