Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

If I have a multi-line comment in a cell above the freezepanes row, and scroll down a couple of rows, the comment is cut off at the freezepanes point. I'm seeing this behavior in Excel 2007, and don't recall that it was a problem in Excel 2003. The entire comment should appear when you hover over the cell, and that has nothing to do with the placement of the cell relative to the freezepanes row or column. Is there a workaround? And can someone confirm whether it's fixed in Excel 2010?

share|improve this question
    
Excel 2010 has the same behaviour as 2007. I'm not awware of a workaround. –  Mike Fitzpatrick Apr 27 '11 at 8:43

1 Answer 1

This will occur whenever the comment size is larger than the frozen pane.

A workaround is to increase the row heights of the frozen rows such that the entire comment fits. It will then be fully visible within the frozen pane.

share|improve this answer
    
This won't work in my case since the comment contains a variable number of lines, and making the frozen heading as high as the maximum comment would leave no room for data. I consider this a regression error since it worked in Excel 2003. –  Ken Paul Sep 20 '13 at 18:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.