Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list & frozen panes naive14 Excel Discussion (Misc queries) 3 February 9th 07 12:49 PM
Frozen panes in Excel should stay put when using autofilter. stuckfly Excel Discussion (Misc queries) 8 March 10th 06 06:18 PM
How do I print frozen panes on each page as a header? cmaurer Excel Discussion (Misc queries) 1 March 9th 06 12:23 AM
How do I Hide frozen panes when printing? Stargiddy Excel Worksheet Functions 0 December 20th 05 06:10 PM
How do i use multiple splits or frozen panes? Pat Excel Discussion (Misc queries) 2 November 14th 05 09:52 PM


All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"