I know you can enter a comment so when you scroll over the column it will
show the comment no matter what line you are on, but I can not remember how
to do this.

Enter the comment on one cell, then Copy PasteSpecial Comments, to the
other cells of interest.......

Vaya con Dios,
Chuck, CABGx3


"Cynthia" wrote in message
...
I know you can enter a comment so when you scroll over the column it will
show the comment no matter what line you are on, but I can not remember
how
to do this.

Think we could also:
Right-click on cell Insert Comment
to enter directly
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Just to clarify that I had lightly "disregarded" your subject line, and
presumed you simply wanted to remember how to insert comments into cells,
individually.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks any how. What I need is when someone is filling in the spreadsheet I
want to make sure they enter only the info needed in that column. I did it
years ago but can not fiqour it out now.........as they say use or lose it.
Thanks
Cynthia

"Max" wrote:

Just to clarify that I had lightly "disregarded" your subject line, and
presumed you simply wanted to remember how to insert comments into cells,
individually.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Perhaps you're referring to data validation's input message ?

Try this:

Select col A
Click Data Validation Input Message tab
Enter some "comments" inside the "Input Message" box
Click OK

The input msg will appear as you scroll down col A
(Is that what you're after ?)

For more on Data Validation, try Debra Dalgleish's excellent coverage. For
starters, try her:
http://www.contextures.com/xlDataVal01.html
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Cynthia" wrote in message
...
Thanks any how. What I need is when someone is filling in the spreadsheet
I
want to make sure they enter only the info needed in that column. I did it
years ago but can not fiqour it out now.........as they say use or lose
it.
Thanks
Cynthia

Thank you CLR, but when I tried this I entered comment in first row then
Highlighted the whole column and Excel frooze up on me.

Oh bye the way, Interesting initials..............same as mine!

Any other ideals?

Thanks Cynthia

"CLR" wrote:

Enter the comment on one cell, then Copy PasteSpecial Comments, to the
other cells of interest.......

Vaya con Dios,
Chuck, CABGx3


"Cynthia" wrote in message
...
I know you can enter a comment so when you scroll over the column it will
show the comment no matter what line you are on, but I can not remember
how
to do this.