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.
 

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

Top