Apply comment to all cells with equal value?

K

Kim

I need to apply the same comment to cells that contain the same value. (phone
numbers).
 
M

Mike H

Kim,

Manually enter the comment in one of these cells then copy the cell. Select
the phone number cells and then

Edit|Paste special - select 'Comments' - OK

Mike
 

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 Import Comments 3
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Question about conditional formatting of zeros in Excel 0
conditional formatting and comments 5
Conditional formating 1
using a popup to make percenatges on selected cells 6
Conditional Formatting - Excel 2003 2
Conditional formatting - check for blank cell 3

Top