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

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.

"Mickey" wrote:

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

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Mickey" wrote in message
...
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

Thanks so much. The website answered all my questions.

"Bob Phillips" wrote:

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Mickey" wrote in message
...
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