en uk

Printing gridlines Microsoft Office 2007

    Gridlines help you understand how your numbers, labels, and formulas are aligned with one another. If you need to print a large spreadsheet, you may want to print gridlines to make it easier to understand.

    To print gridlines and/or row and column headings, follow these steps:

    1. Click the Page Layout tab.

    2. (Optional) Select the Print check box under the Gridlines category.

    3. (Optional) Select the Print check box under the Heading category.

    Defining a print area

    Sometimes you may not want to print your entire spreadsheet but just a cer­tain part of it, called the print area. To define the print area, follow these

    Steps:

    1. Select the cells that you want to print.

    2. Click the Page Layout tab.

    3. Click the Print Area icon in the Page Setup group.

    A pull-down menu appears, as shown in Figure 7-22.

    Printing gridlines Microsoft Office 2007

    Figure 7-22:

    The Print Area menu lets you define or clear the printable cells.

    4. Choose Set Print Area.

    Excel displays a dotted line around your print area.

    5. Click the Office Button and then click the right-pointing arrow that appears to the right of Print.

    A print menu appears.

    6. Choose Quick Print (to print) or Print Preview (to see what your spreadsheet will look like before you print it).

    After you define a print area, you can see which cells are part of your print area by clicking the downward-pointing arrow of the Name box and choosing Print_Area.

    After you define a print area, you can always add to it by following these steps:

    1. Select the cells adjacent to the print area.

    2. Click the Page Layout tab.

    3. Click the Print Area icon in the Page Setup group.

    A pull-down menu appears.

    4. Choose Add to Print Area.

    Excel displays a dotted line around your newly defined print area.

    After you define the print area, you can always remove it by following these steps:

    1. Click the Page Layout tab.

    2. Click Print Area.

    A pull-down menu appears (refer to Figure 7-22).

    3. Choose Clear Print Area.

    Inserting (and removing) page breaks

    One problem with large spreadsheets is that when you print them out, parts may get cut off when printed on separate pages. To correct this problem, you can tell Excel exactly where page breaks should occur.

    To insert page breaks, follow these steps:

    1. Move the cursor in the cell to define where the vertical and horizontal page breaks will appear.

    2. Click the Page Layout tab.

    3. Click the Breaks icon in the Page Setup group.

    A pull-down menu appears, as shown in Figure 7-23.

    4. Choose Insert Page Break.

    Excel inserts a horizontal page directly above the cell you selected in Step 1 and a vertical page break to the left of that cell, too.

    Printing gridlines Microsoft Office 2007

    Figure 7-23:




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.