Drop down list

[justineb]

Hi
I'm using Excel 2007 and have forgotten how to create a drop down list.

Can anyone help?

Thanks!

 

[Jeshua]

I'm not sure about 2007 but in 2003 it's under data - validation then from the allow select list and then choose the range of data you want to use in the drop down in the source box. Eg =A1:A50 if the data you want to use is in a1 through a 50

 

[Michael M]

Hi justineb
Welcome to the Board
Do you mean a data validation list.
I don't know about 07 but Data / Validation in other versions will do the trick.
Try the Help menu for Data Validation

Regards
Michael M

 

[shemayisroel]

This may help you...

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

 

[justineb]

Perfect!

Thank you!!

 

[shemayisroel]

Perfect!

Thank you!!

Your welcome