XL97: Printing Problem When Print Titles Contain Borders

Last reviewed: February 12, 1998
Article ID: Q164024
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you print or view a worksheet in print preview, the first row of each printed page after the first page may contain text from another location in the worksheet.

CAUSE

This problem may occur when all of the following conditions are true:

  • You specify a range in the "Rows to repeat at top" box in the Sheet tab of the Page Setup dialog box to create print titles.

        -and-
    
  • One or more of the cells in the last row of the range you specify are formatted with a bottom border of medium weight.

        -and-
    
  • Text in any of the cells in the first row after the print titles range is located close to the top of the cell.

    For example, a cell is formatted to use a top vertical alignment, or the height of a cell barely accommodates the text in the cell.

NOTE: This problem does not occur in earlier versions of Microsoft Excel. Also, this problem does not occur unless at least one cell in the last row of the print titles range is formatted with a medium bottom border. Hairline, thin, and thick borders do not cause the problem to occur.

WORKAROUND

To work around this problem, move the text in the first row after the print titles range away from the top of the cells. To do this, use the following steps:

  1. Select the first row after the print titles range.

    For example, if the print titles are rows 1 - 3, select row 4.

  2. On the Format menu, click Cells.

  3. Click the Alignment tab.

  4. In the Vertical list box, click Bottom. Then, click OK.

  5. On the Format menu, point to Row, and then click Height.

  6. In the Row Height box, increase the value by 0.75.

    For example, if the box contains the value 12.75, increase it to 13.50.

  7. Then, click OK.

After you complete these steps, print the worksheet or view it in print preview.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 for Windows, Service Release 1.

MORE INFORMATION

In Microsoft Excel, you can use a print titles range to print selected rows (or columns) at the top (or the left side) of each page. To set a print titles range on a worksheet, use the following steps:

  1. On the File menu, click Page Setup, and then click the Sheet tab.

  2. In the "Columns to repeat at left:" box, specify the range of columns that you want to print at the left side of each worksheet (for example, column A or columns A through D). In the "Rows to repeat at top:" box, specify the range of rows that you want to print at the top of each worksheet (for example, row 1 or rows 1 through 5).

  3. Click OK.

Note that if any of the cells in the last row in the cell range you want to print at the top of the worksheet are formatted with a medium weight bottom border, extra text may be printed in the first row of some pages. In particular, a "slice" of the top of the first row after the print titles row is printed on each page after the first page.


Additional query words: XL97
Keywords : xlformat xlprint kbprint kbualink97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround


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: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.