Drop downs

  • Thread starter Thread starter How do add Drop down list
  • Start date Start date
H

How do add Drop down list

How do I add drop down list in my excel spreadsheet so that it would look
like a database where in I can choose options in a single cell.
 
In Office 2007, look under the 'Data' tab up in the ribbon. With the cell you
want to use for the drop-down menu selected, hit "Data Validation". Here you
can set the values users are allowed to enter into the cell - the drop-down
menus are under the option "Allow:List" in the validation categories. The
data for the list should be in the form of a range - either in the format
=$A$2:$A$20 which contain your different options, or in a named range with
the same options. Hope that helps.
 

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

Filtered drop down list 2
Linking Excel drop down lists 2
Drop Down List in Excel 2007 1
List and Data Validation 1
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
drop downs 2
How to delete a drop down box in Excel 2007 1
Adding more options in a drop down list 4

Back
Top