How do i set up a dropdown listbox of values in a column of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'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
Click to expand...

I think you need Data Validation for this. Menu Data>Validation>
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
 
Back
Top