List boxes in excel forms

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

Can someone please tell me how to enter values in an excel
drop down list box? I am not an advanced user and am
really struggling!

Thanks
 
Hi Liz!

Two ways:

Select the cell where you want the list box to be
Data > Validation > Allow
Select List
Type in the list separated by commas.

Type in your list in a range of cells
Select the cell where you want the list box to be
Data > Validation > List
Type in the reference to your range of cells.

If the range is not on the same sheet, you need to name it and refer
to it by name.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top