Copy comments to several sheets in a workbook?

G

Guest

Does anyone know how to copy a cell's comment to several active sheets within
a workbook all at once? For instance, you can make several of the sheets
active within a workbook, alter a number in a cell, and the number will
change on all sheets in the same cell at once. Can this be done with
comments? I have only been able to do it from one sheet to another and not
with multiple sheets at once. Any help would be appreciated.
 
D

Debra Dalgleish

You can't insert a comment on multiple sheets simultaneously.

You could copy the cell that contains the comment

Then switch to another sheet, and choose Edit>Paste Special
Select Comment, click OK

Select the next sheet, select a cell, and press the F4 key
Repeat this last step for all remaining sheets

Or, you could create a macro to copy and paste a comment.
 

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

Copy data to multiple sheets 2
printing page # on sheets 1
Save all sheets in a new workbook 7
move worksheet to end of another workbook 3
How do you chart data from multiple sheets within a workbook? 3
Copy formatted in several sheets of a workbook 1
need code for hiding/unhiding sheets using checkboxes 1
formatting sheets in a workbook 4

Top