Copy Comments
 

How do I copy comments to more than one worksheet. I can do so sheet to sheet
but would like to be able to copy of 30+ sheets at one time.

Copy Comments
 

I don't know of a way to paste the comments on all sheets at the same
time, but the following method should be pretty quick --

Copy the cells that contain the comments.
Select the first sheet on which you want to paste the comments
Select the cell where you want to start the paste
Choose EditPaste Special
Select Comments, click OK

Select the next sheet, and starting cell, and press the F4 key, to
repeat the paste special.
Repeat the last step for the remaining sheets

field8585 wrote:
How do I copy comments to more than one worksheet. I can do so sheet to sheet
but would like to be able to copy of 30+ sheets at one time.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html