Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
resize and move all comments in one step
I am needing to resize and move all my comments on my workbook to their
relevant cells as when I try to hide or group colums it says that I "can't move objects off sheet". I assume that this is because my comments seem to have a life of their own and have landed up in random places on my worksheet. Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
resize and move all comments in one step
I'd use a macro.
Debra Dalgleish has a couple for you: http://contextures.com/xlcomments03.html#Reset http://contextures.com/xlcomments03.html#Resize If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm (Look for merged cells, too.) EvelynB wrote: I am needing to resize and move all my comments on my workbook to their relevant cells as when I try to hide or group colums it says that I "can't move objects off sheet". I assume that this is because my comments seem to have a life of their own and have landed up in random places on my worksheet. Please help! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
resize and move all comments in one step
hi
there is a wealth of information on comments at this site. this link directs you to reseting and resizing but scroll up and down the page for more infor on more stuff. http://www.contextures.com/xlcomments03.html#Reset regards FSt1 "EvelynB" wrote: I am needing to resize and move all my comments on my workbook to their relevant cells as when I try to hide or group colums it says that I "can't move objects off sheet". I assume that this is because my comments seem to have a life of their own and have landed up in random places on my worksheet. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't select, move or resize an image in Excel?? | Excel Discussion (Misc queries) | |||
Cursor not displaying properly to resize/move columns/tables | Excel Discussion (Misc queries) | |||
Cell Comments randomly move and resize regardless of settings | Excel Discussion (Misc queries) | |||
Move/Resize PlotArea | Charts and Charting in Excel | |||
Why can't I resize/move objects in XL XP chart? | Excel Discussion (Misc queries) |