XL2000: Comments Are Obscured, Truncated If Immediately Above Frozen Pane

• Microsoft Excel 2000

SYMPTOMS

If a worksheet cell that contains a comment is located above a frozen pane, the comment may appear partially obscured or truncated at the border of the frozen pane when you scroll the document.

CAUSE

In Excel 2000, comments are on sheet objects and, therefore, 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 was 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.

REFERENCES

For more information about comments, click Microsoft Excel Help on the Help menu, type displaying comments in the Office Assistant or the Answer Wizard, and then click Search to view "Hide or display comments and their indicators."

For more information about panes, click Microsoft Excel Help on the Help menu, type frozen panes in the Office Assistant or the Answer Wizard, and then click Search to view "Keep row and column labels visible as you scroll."

Additional query words: freeze note XL2000 static non-moving

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb