Microsoft KB Archive/247301

From BetaArchive Wiki
Knowledge Base

XL97: Borders Lost in Cells Repeated at Top with Filtered Data

Article ID: 247301

Article Last Modified on 7/17/2001


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q247301


When you print or print preview a workbook, cell borders are missing from cells that are repeated at the top of every page. This problem occurs on all pages except the first page.


This problem occurs when all of the following conditions are true:

  • The data below the rows to be repeated are filtered.


  • The cell immediately below the row to be repeated contains data that does not meet the current filter criteria.


  • The print area spans more than one page.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL97 headers lines gridlines

Keywords: kbbug kbfix KB247301