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
confusing.

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?

Hi dphuz-ga,

Here's your solution :

Microsoft Excel Validation DropDown ListBox
http://www.beyondtechnology.com/tips018.shtml

...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
http://www.unm.edu/~tectrain/QuickTipTutorials/xcelautofill.html



Google Search Term :

excel dropdown list
://www.google.com/search?sourceid=navclient&q=excel+dropdown+list

excel autofill
://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=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
Answers.


Regards,

kyrie26-ga

---

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.

kyrie26-ga

Perfect. Exactly what I needed, and quick. Thank you very much.