Excel: Creating the Appearance of Multiple-Line Headers

Last reviewed: November 4, 1994
Article ID: Q63029

SUMMARY

In Microsoft Excel for the Macintosh, headers or footers cannot have more than one line. However, it is possible to get the effect of a multiple-line header by following the steps below.

MORE INFORMATION

Excel 3.0

Note: This process will give the appearance of headers, but it requires that certain concessions be made. These include setting aside the first rows for the header information, using print titles for those rows, possibly turning off row and column headings when printing, and using borders instead of gridlines.

  1. Insert as many blank rows at the start of the document as are desired in the header.

  2. From the File menu, choose Page Setup and cancel the Print Gridlines option. To turn off the display of gridlines on the screen, choose Display from the Options menu and cancel the Gridlines box.

  3. If you want gridlines on the spreadsheet, select the entire spreadsheet except for the header lines, and apply right, left, top, and bottom borders to the selected cells by choosing Border from the Format menu. This simulates the appearance of gridlines on the printout, but will leave the header lines without grids, as a real header would also be.

    Note: Borders are solid lines, whereas gridlines are dotted lines, so the appearance will not be exactly the same.

  4. Select the header lines in the document (by clicking on the entire row for each line) and choose Set Print Titles from the Options menu. This will print the header lines on each page as if they were actual headers.

  5. If the worksheet is more than one page wide, the titles must be typed or pasted into the header area for each extra page in width. If this is not done, pages to the right of the first page have print titles that are blank.

  6. You can also cancel the Print Row And Column Headings option in the Page Setup dialog box. This will remove the row and column headings, which will give the header a more realistic appearance. However, this will remove row and column headings for the entire document.


KBCategory:
KBSubcategory:

Additional reference words: 2.20 3.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.