View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default Drop Down Pick List

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