View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default How do i set up a dropdown listbox of values in a column of cells

On May 31, 1:59 pm, TheRulie
wrote:
I'm trying to create a drop down list box in my excel sheet that is populated
by a list of values. For each cell in the column I want this drop down to
appear.

It's effectively a pick list ..

Any ideas on how to do this?

Thanks


I think you need Data Validation for this. Menu DataValidation
choose List. You first select the entire range of cells before you
apply it. If the list of numbers is in the same sheet you just select
them in the reference box that appears in the DV dialog box when you
choose List. If your list is in another sheet you must first name it
and use the name in DV.

HTH
Kostis Vezerides