Google Answers Logo
View Question
Q: MS Excel 2002- Specifying a list of valid options for a cell ( Answered 5 out of 5 stars,   0 Comments )
Subject: MS Excel 2002- Specifying a list of valid options for a cell
Category: Computers > Software
Asked by: dphuz-ga
List Price: $10.00
Posted: 01 Nov 2002 11:04 PST
Expires: 01 Dec 2002 11:04 PST
Question ID: 95645
Need MS EXCEL 2000 help.  I'm pretty sure this can be done, but i'm
not sure how. I looked through the help files and found them pretty

For each cell in a specic column, there are only 3 acceptable options,
and I need users to be able to pick them from a list. To simplify,
lets say I've got a spreadsheet listing an inventory of cars. I've got
a column called "color"  and the only things that can go
in any cell in that column are "red" "blue" or "white". 

For every car in inventory, (thus every cell in the color column), I
want users to have a dropdown list (or something similar) containing
"red" "blue" and "white" to pick from.  There will be 100s cars, thus
100s of entries in the "color" column. I need the list of options to
appear for every cell someone
clicks in. 

How do I set it up?
Subject: Re: MS Excel 2002- Specifying a list of valid options for a cell
Answered By: kyrie26-ga on 01 Nov 2002 11:14 PST
Rated:5 out of 5 stars
Hi dphuz-ga,

Here's your solution :

Microsoft Excel Validation DropDown ListBox

...and if you want a whole column (or row) of cells to have this
dropdown list feature, all you need to do is Autofill the rest of the
cells :

MS Excel Autofill

Google Search Term :

excel dropdown list

excel autofill

Hope this helps. If not, please do not hesitate to ask for a Request
For Clarification and I would be more than happy to do further
research until you find the solution. Thank you for using Google



Request for Answer Clarification by dphuz-ga on 01 Nov 2002 12:16 PST
your answer was great. do you know if there's a way to put a default
value in all the cells. like in my original example, suppose all cars
are white by default, and only red or blue in special cases.  is there
a way to have the whole column read "white", so that users would only
change to red or blue if necessary? I'd hate to make users pick
"white" every time if 90% of the cars are going to be white anyway.

Clarification of Answer by kyrie26-ga on 01 Nov 2002 14:19 PST
Hi again dphuz-ga,

All you need to do is select the value you want (ie. white) on the
first cell, and do an Autofill (drag copy) down. The other cells will
also be set to "white" as default.

If this doesn't work, let me know.

Have fun! Thanks for the 5 stars.

dphuz-ga rated this answer:5 out of 5 stars
Perfect. Exactly what I needed, and quick. Thank you very much.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy