Hi Brad,

See Data | Validation.

Debra Dalgleish has a tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"Brad" wrote in message
...
Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct
one.

I have seen drop down lists on some spreadsheets that were in the cell,
not
a regular drop down list. This list shows up when you click on the cell,
but
when you move away from the cell, the arrow dissappears and the chosen
value
remains. You create a list somewhere else that is the list of values in
the
drop down list.

I hope this makes sense.

Brad