Comments Without Indicators; Displayed when Cells are Clicked

K

katzy

I am interested in creating comments that do not have indicators, and that
appear when the cell is clicked. These comments can be moved around, but
cannot actually be edited by someone using the worksheet.
I've noticed this in a spreadsheet that I have that needs to be edited. I
need to recreate some of these comments with the proper information inside.
Any ideas?
(Excel 03)

Thanks-
 
A

akphidelt

Try going to

Date-->Validation

Leave it at Any Value

Then go to Input Message and type in a comment that you would like the user
to see. This eliminates the indicator but still shows a comment when clicked.
 

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

Can I protect data in a cell, but allow comments to be entered. 6
deleting comments 2
Can't Edit Cell Comments 1
Comments not moving when columns are sorted 4
Comments box, kinda. 1
Excel comments moving and changing sizes 2
Need to add cell comments in unlocked cell on protected worksheet 3
Can't Edit comments (XL 2007) 1

Top