View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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 EditPaste Special
Select Comments
Click OK

Lance wrote:
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.



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