Drop down

[Laura \( '_' \)]

Hi, I'd like to have a dropdown bar in my excel 2000 with about 10 options
to choose from. How would I go about making this?
Thanks in advance.

 

[Max]

Try Debra's excellent coverage of data validation:
http://www.contextures.com/xlDataVal01.html

 

[Laura \( '_' \)]

Thankyou very much Max, I'll take a look now!

 

[Max]

You're welcome, Laura
Debra's shoppe is open 24 x 7 !