ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comments Not displaying Correctly With Panes Frozen? (https://www.excelbanter.com/excel-discussion-misc-queries/141948-comments-not-displaying-correctly-panes-frozen.html)

Mattie

Comments Not displaying Correctly With Panes Frozen?
 
I have a worksheet with a few rows and columns that are frozen. Whenever I
add or view comments I always see the "frozen line" overtop of my comment
entry box. It is there when i view the comments as well. Is there a way to
do away with this "frozen line"?

And the biggest problem is when viewing comments on this same worksheet, I
can view them only when my sheet is scrolled all the way to the left. If I
scroll the sheet a few columns to the right, I get truncated info (which
dissapears after it passes the "frozen line"). Hope that isn't too confusing
:/

Thanks

Gord Dibben

Comments Not displaying Correctly With Panes Frozen?
 
Mattie

No way to do away with the line that runs through the comments or un-truncate
the comment when you scroll to the right.


Gord Dibben MS Excel MVP

On Tue, 8 May 2007 07:09:03 -0700, Mattie
wrote:

I have a worksheet with a few rows and columns that are frozen. Whenever I
add or view comments I always see the "frozen line" overtop of my comment
entry box. It is there when i view the comments as well. Is there a way to
do away with this "frozen line"?

And the biggest problem is when viewing comments on this same worksheet, I
can view them only when my sheet is scrolled all the way to the left. If I
scroll the sheet a few columns to the right, I get truncated info (which
dissapears after it passes the "frozen line"). Hope that isn't too confusing
:/

Thanks




All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com