It is called Data Validation. Good tutorial at
http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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