Microsoft KB Archive/173347: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 84: Line 84:


</div>
</div>
and then double-click the selected text to go to the &quot;displaying&quot; topic.<br />
and then double-click the selected text to go to the "displaying" topic.<br />
<br />
<br />
For more information about frozen panes, click the Index tab in Microsoft Excel Help, type the following text
For more information about frozen panes, click the Index tab in Microsoft Excel Help, type the following text
Line 93: Line 93:


</div>
</div>
and then double-click the selected text to go to the &quot;Keep row and column labels visible as you scroll&quot; topic.
and then double-click the selected text to go to the "Keep row and column labels visible as you scroll" topic.


</div>
</div>

Latest revision as of 10:06, 21 July 2020

Knowledge Base


Article ID: 173347

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



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

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: kbprb KB173347