Setting and Viewing Page Breaks

Excel determines where one printed page ends and the next begins based on your page size, margins, and orientation; however, the page breaks Excel sets might not work for a particular worksheet. You might want to have a chart or table placed on its own sheet, or you might want to force two separate tables onto one printed page. You can display all existing page breaks by opening your worksheet in Page Break Preview mode, which displays the page breaks as blue lines. If the blue lines are dashed, they represent an automatic page break; if the blue lines are solid, they represent a manually set page break. While in Page Break Preview, you can change the location of any existing page breaks to ensure your worksheets print exactly the way you want.

View Current Page Breaks

  1. Click the View tab.

  2. Click Page Break Preview.

    View Current Page Breaks

Set Manual Page Breaks

  1. Click the cell the below and to the right of where you want to insert a page break.

  2. Click the Page Layout tab.

  3. Click Breaks.

  4. Click Insert Page Break.

  5. On the status bar, click the Normal button to exit Page Break Preview.

    Set Manual Page Breaks

Change Manual Page Breaks

  1. Click the View tab.

  2. Click Page Break Preview.

  3. Hover the mouse pointer over one of the blue lines until the mouse pointer becomes a two-headed arrow. Drag the line until the page break is where you want.

    Change Manual Page Breaks
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.217.251.56