Drop Down Pick List

[Guest]

I am new to excel and would like to know if it's possible to have a drop down
pick list. I need users to pick from a specific list instead of having them
type what they want. I don't want the list to filter.

Thanks,
Mickey

 

[Guest]

Select the cell in which you want the drop-down. Then from the menu bar,
select Data / Validation. Choose List in the first drop-down and then type
the valid entries in the next text box (A,B,C ...) or, better yet, reference
a named list elsewhere in your workbook.

 

[Bob Phillips]

You want data Validation. See http://www.contextures.com/xlDataVal01.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

Thanks so much. The website answered all my questions.