Comments for multiple cells

[eddd82]

How do u make the same comment appear when the mouse is moved over different cells. Basically ive bout 20 cells which each have the same comment. just tryin to do it the short way?

 

[Audiojoe]

You could copy the comment into all the boxes. Just copy the comment then:

Paste Special> Comments

Audiojoe

 

[Robb__]

Ed

Just put a comment in one of the cells and then copy the cell to the others - the comment will copy across.

Just a note of caution though - if you later copy a value into any of the cells, use pastespecial/values or you may delete the comment.

Any help?

Regards

Robb__

 

[eddd82]

Aye thatll do the job I just thought there would be a way of selecting a load of cells and inserting the one comment for the lot.