Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
I have a very large Spreadsheet with entries in Column A. The cells also
contain a comment to let the user know what kind of entries should be on a particular row. When the user freezes the pane with column A showing why can we no longer see the comment? Is there an easy way to keep the comment visible when the user scrolls to the right? TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Using Comments.....No easy way.........not even sure if there is hard way<g
Instead of cell Comments try a Data Validation Input Message. Gord Dibben MS Excel MVP On Sun, 30 Nov 2008 12:19:01 -0800, Chris waller wrote: I have a very large Spreadsheet with entries in Column A. The cells also contain a comment to let the user know what kind of entries should be on a particular row. When the user freezes the pane with column A showing why can we no longer see the comment? Is there an easy way to keep the comment visible when the user scrolls to the right? TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
your comments will only be visible when the user scrolls back to the starting
cells that are next to the cells that have the comments in them, the only way now to make your comments appear is to freeze the panes after one more cell and adjust the size of the comment using "edit comment" so that it fits into the size of that cell. you can also adjust the size of the cells to fit for your comment's actual size so that when he targets the cell none of the comment will be cut when freeze panes is applied. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Hi,
I prefer the Data Validation choice but the drawback is there is no indicator that a comment exists. So to see it the user must select the cell. Another alternative is to insert a new column to the left of column A and put the comments in that columns. Narrow that column and leave the freeze panes on the new column B. Widen column B enough so you can see the complete comments. If this helps, please click the Yes button. Cheers, Shane Devenshire "Chris waller" wrote: I have a very large Spreadsheet with entries in Column A. The cells also contain a comment to let the user know what kind of entries should be on a particular row. When the user freezes the pane with column A showing why can we no longer see the comment? Is there an easy way to keep the comment visible when the user scrolls to the right? TIA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Thanks for all the replies. I will certainly give all your answers a go.
"Chris waller" wrote: I have a very large Spreadsheet with entries in Column A. The cells also contain a comment to let the user know what kind of entries should be on a particular row. When the user freezes the pane with column A showing why can we no longer see the comment? Is there an easy way to keep the comment visible when the user scrolls to the right? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comments | Excel Discussion (Misc queries) | |||
Comments | Excel Discussion (Misc queries) | |||
comments | Excel Worksheet Functions | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Comments | Excel Discussion (Misc queries) |