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