XL2000: Borders Near Hidden Cells May Not Be Displayed or Printed (211647)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211647

SYMPTOMS

When you print a Microsoft Excel worksheet that contains hidden cells adjacent to visible cells that have been formatted with a border, the border may not be printed. It also may not be displayed in Print Preview.

CAUSE

This behavior can occur when the following conditions are true:
  • The border is applied to the side of a cell that is next to a hidden column or row. - and -

  • The column or row that contains the cell with the border is the last visible column on the right, or the last visible row at the bottom of the spreadsheet.

STATUS

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

REFERENCES

For more information about borders, click Microsoft Excel Help on the Help menu, type apply borders to cells in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbpending kbprint KB211647
©2003 Microsoft Corporation. All rights reserved.