Adding a comment to a cell

M

mancitmis

Hi,

New to here, just a quick question.

I know how to add a comment to a cell so that when the cursor moves
over it, it appears.

How do I produce a comment that appears only when the cell is clicked?

Apreciate your help.

Thanks in advance
 
M

mrjsoftware

There's no 'real' way to do this, but one way would be to use the
'Input Message' feature of the Data Validation tool.

Go to Data>Validation...Input Message tab and check 'Show Input message
when cell is selected'. Then type your message in the box provided.
 
Top