Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Lookup Text in Comments | Excel Worksheet Functions | |||
Include comments on another spreadsheet | Excel Discussion (Misc queries) | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Printing hidden comments | Excel Discussion (Misc queries) |