XL97: Comments Are Resized Unexpectedly

ID: Q188507

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

A comment in a worksheet cell may be resized unexpectedly so that the comment box object is only slightly visible when you rest the mouse pointer over the comment marker.

CAUSE

This problem may occur when the following conditions are true:

You use the Advanced Filter feature to filter a list in-place, and the list contains comments.

-or-

You have inserted a comment into a cell.
```
    -and-
```
You increase the size of the row above the row containing the comment.
```
    -and-
```
You immediately insert a row above the row containing the comment.

WORKAROUND

To work around this problem, manually resize the comment. To do so, follow these steps:

1. Right-click the cell that contains the comment, and then click Show

   Comment on the menu that appears.

2. Click the border of the comment. Use the resize handles that appear

   to resize the comment.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q169053
   TITLE     : XL97: Comments May Not Be Printed as Expected

   ARTICLE-ID: Q173347
   TITLE     : XL97: Comments May Be Obscured by Freeze Panes

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.

Additional query words: XL97

Keywords          : kbdta xldraw 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: April 28, 1999