en uk

Printing row and column headings Microsoft Office 2007

    If you have a large spreadsheet that fills two or more pages, Excel may print your spreadsheet data on separate pages. Although the first page may print your labels to identify what each row and column may represent, any addi­tional pages that Excel prints won't bear those same identifying labels. As a result, you may wind up printing rows and columns of numbers without any labels that identify what those numbers mean.

    To fix this problem, you can define labels to print on every page by following these steps:

    1. Click the Page Layout tab.

    2. Click the Print Titles icon in the Page Setup group.

    The Page Setup dialog box appears, as shown in Figure 7-24.

    Printing row and
column headings Microsoft Office 2007

    Figure 7-24:

    The Page Setup dialog box lets you define the row and column headings to print on every page.

    3. Click the Collapse/Expand button that appears to the far right of the

    Rows to Repeat at Top text box.

    The Page Setup dialog box shrinks.

    4. Click in the row that contains the labels you want to print at the top of every page.

    5. Click the Collapse/Expand button again.

    The Page Setup dialog box reappears.

    6. Click the Collapse/Expand button that appears to the far right of the Columns to Repeat at Left text box.

    The Page Setup dialog box shrinks.

    7. Click in the column that contains the labels you want to print on the left of every page.

    8. Click the Collapse/Expand button again.

    The Page Setup dialog box reappears.

    9. Click OK.




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.