how to install a drop down list excel 2002

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

Guest

I have a table with a column I want to let the user choose from a list of
words to fill the cell. I have made a list of the words on my worksheet
below my table. How do I get the drop down list to happen in the column.
Thanks
 
Suppose your words list is in say: A10:A12

Select A1 (or select the range, say A1:A3)
Click Data > Validation
Allow: List
Source: =$A$10:$A$12
Click OK.
 
Thanks Max. I read it is not advisable to have more than one of these lists
per worksheet. Is this correct or could I have several columns with drop
down choices?
 
The instructions Max gave you are for items lists on the same sheet as
the dropdown lists.
If you want to use different dropdown lists in multiple columns, it's a
good idea to store the item lists on a different sheet. Then, name the
lists, and refer to the names in the data validation dialog box, as
described here:

http://www.contextures.com/xlDataVal01.html
Maybe the advice you saw suggested storing each of the source lists on a
separate sheet.
 
Not sure Debra. My work around for now is one list and then reference
different cell range in validation. Appears to be working so far.
 

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

Formatted cell column in drop down list 1
Excel Excel: How do I put a formula in a drop down list 11
dependent drop down list 1
DATA VALIDATION/DROP DOWN LIST 1
Dependent drop down dynamic range formula, off sheet. 7
drop-down list 2
Drop Down Lists 2007 10
use v lookup from a drop down list 5

Back
Top