XL97: Comments May Be Obscured by Freeze Panes (173347)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q173347 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
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
and then double-click the selected text to go to the "Keep row and column
labels visible as you scroll" topic.
Modification Type: | Major | Last Reviewed: | 10/22/2000 |
---|
Keywords: | kbprb KB173347 |
---|
|