Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some comments stay hidden even after picking show/hide all why?
Excell question-- I use comments on many cells, and copy contents around in
multiple sheets, then edit the comments. Sometimes a comment won't show when I want to edit it and i have to first say show, then edit yet others are not like that. I want to know how I can pick all and set all to show at once and have the setting stick! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some comments stay hidden even after picking show/hide all why?
Goto Tools - Options, View tab. Under 'comments', select "none" then hit ok.
(This is to reset everything). Go back into options, and now select the "Comment & Indicator" option. Hit ok. All comments should now be visible. This should now affect all your comments throughout the workbook. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stevepowell" wrote: Excell question-- I use comments on many cells, and copy contents around in multiple sheets, then edit the comments. Sometimes a comment won't show when I want to edit it and i have to first say show, then edit yet others are not like that. I want to know how I can pick all and set all to show at once and have the setting stick! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some comments stay hidden even after picking show/hide all why
sorry.. for 2007 version...
"Luke M" wrote: Goto Tools - Options, View tab. Under 'comments', select "none" then hit ok. (This is to reset everything). Go back into options, and now select the "Comment & Indicator" option. Hit ok. All comments should now be visible. This should now affect all your comments throughout the workbook. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "stevepowell" wrote: Excell question-- I use comments on many cells, and copy contents around in multiple sheets, then edit the comments. Sometimes a comment won't show when I want to edit it and i have to first say show, then edit yet others are not like that. I want to know how I can pick all and set all to show at once and have the setting stick! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Show/Hide Comments Not Working | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Comments don't stay the size I choose. | Excel Worksheet Functions | |||
HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) |