Copy Comments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Making a Sheet copy 3
Word to Excel: Export comments with text and line number 0
Printing Worksheet 1
dynamic data copying between worksheets 0
Worksheet + 1 1
SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Comment in protected sheet 6

Back
Top