Copy Comments

F

field8585

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.
 
D

Debra Dalgleish

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 Edit>Paste 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
 
Top