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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Drop Down Box populated by a List 1
Filtered drop down list 2
Drop Down List Location Question 3
Max number of drop-down list elements in excel 3
Protecting sheets with drop down boxes 6
Excel Query setup 0
Select a formula / range from Excel drop down suggestions 6
How to delete a drop down box in Excel 2007 1

Back
Top