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

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

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

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