• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9. Printing in Excel > Working in Page Break Preview Mode

Working in Page Break Preview Mode

Choose View, Page Break Preview. If a print area has been set, it is displayed; if not, the entire worksheet is displayed.

Move through the worksheet to find page breaks (if any). Naturally occurring page breaks appear as blue dashed lines, and inserted page breaks appear as solid blue lines.

INTRODUCTION

Page Break Preview mode displays the area you have selected for your set print area. It also allows you to click and drag where your page breaks are instead of using the Insert, Page Break command. You can also edit the text and data just as you can in Normal view.


TIP

Clearing the print area

If you only need to set the print area to print a portion of data in your worksheet once, you will probably want to clear the print area after you print. Open the File menu, choose Print Area, and select Clear Print Area to clear the previously set print area.


To move a page break that is poorly placed, click and drag it to a better location. (Moving a natural page break changes it to an inserted break—solid-blue.

To exclude a column or data to the right of your set print area, click and drag the vertical page break.

The excluded column outside the print area is grayed out.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint