How can I Insert a Comment into multiple cells in Excel 2003?

G

Guest

I'd like to select various cells in a spreadsheet, then insert a comment
which will show up on all of them. It won't let me do it, and this could save
me hours of work.
 
D

Debra Dalgleish

Insert the comment into one cell
Copy the cell that contains the comment
Select all the other cells in which you want the comment
Choose Edit>Paste Special
Select Comments
Click OK
 

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

Can insert digital ink into Excel cell or a cell comment? 1
How DO I Increase The Excel Cell Comment Data Capacity? 1
Keyboard shortcut to insert comment in excel 3
How to copy comment box to other cells 3
XL2003: Move a Comment Into a Different Cell? 6
HOW DO i SHOW SAME COMMENT TO TWO OR MORE CELLS IN EXCEL 5
How do I insert a photo into a specific cell? 3
How do I display spreadsheet comments in a chart? 1

Top