#1   Report Post  
Phippsy
 
Posts: n/a
Default Hidden Comments

If a comment is created in row 1 and then freeze panes has been applied to
row 2 the comment becomes hidden behind the frozen rows. Other than adding
some blank rows or making the first row deeper is there any other way of
showing the comment over the top of the freeze rows line?

Thanks
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default Hidden Comments

I don't believe it is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Phippsy" wrote in message
...
If a comment is created in row 1 and then freeze panes has been
applied to
row 2 the comment becomes hidden behind the frozen rows. Other
than adding
some blank rows or making the first row deeper is there any
other way of
showing the comment over the top of the freeze rows line?

Thanks



  #3   Report Post  
Ragdyer
 
Posts: n/a
Default Hidden Comments

You could use the Data Validation "InPut Message".

However, it *only* displays when the cell is selected, and there's no cell
"indicator" to make one aware of its existance.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phippsy" wrote in message
...
If a comment is created in row 1 and then freeze panes has been applied to
row 2 the comment becomes hidden behind the frozen rows. Other than adding
some blank rows or making the first row deeper is there any other way of
showing the comment over the top of the freeze rows line?

Thanks


  #4   Report Post  
Phippsy
 
Posts: n/a
Default Hidden Comments

Sounds like a good idea - thanks.

"Ragdyer" wrote:

You could use the Data Validation "InPut Message".

However, it *only* displays when the cell is selected, and there's no cell
"indicator" to make one aware of its existance.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Phippsy" wrote in message
...
If a comment is created in row 1 and then freeze panes has been applied to
row 2 the comment becomes hidden behind the frozen rows. Other than adding
some blank rows or making the first row deeper is there any other way of
showing the comment over the top of the freeze rows line?

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
Copy without Hidden Cols - How abrogard Excel Discussion (Misc queries) 1 July 15th 05 07:54 AM
Lookup Text in Comments malik641 Excel Worksheet Functions 2 July 5th 05 12:36 PM
Include comments on another spreadsheet jh3016 Excel Discussion (Misc queries) 1 July 3rd 05 12:24 PM
Can I reference comments by Cell Name? flo1730 Excel Discussion (Misc queries) 5 June 15th 05 03:34 PM
Printing hidden comments Tammy Excel Discussion (Misc queries) 1 May 24th 05 02:16 AM


All times are GMT +1. The time now is 10:43 AM.

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

About Us

"It's about Microsoft Excel"