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! |
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 |
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! |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com