XL97: Comments May Be Obscured by Freeze Panes

 Last reviewed: January 7, 1998
Article ID: Q173347
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, if a worksheet cell containing a comment is located above a frozen pane, the comment may appear partially obscured or truncated at the border of the frozen pane.

CAUSE

Comments in Excel 97 are on sheet objects, and behave like other objects on the worksheet when you scroll the document. In the frozen pane, Excel only displays the portion of the comment that would normally appear in that part of the worksheet if the pane were not frozen.

WORKAROUND

To prevent this behavior, click Unfreeze Panes on the Window menu, or select a row underneath the comment before clicking the Freeze Panes command.

STATUS

This behavior is by design of Excel 97.

REFERENCES

For more information about comments, click the Index tab in Microsoft Excel Help, type the following text 

   Comments
and then double-click the selected text to go to the "displaying" topic.

For more information about frozen panes, click the Index tab in Microsoft Excel Help, type the following text 

   Panes
and then double-click the selected text to go to the "Keep row and column labels visible as you scroll" topic.

Additional query words: XL97 freeze note
Keywords : xlui
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: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.