MS Excel 2002- Specifying a list of valid options for a cell
Category: Computers > Software
Asked by: dphuz-ga
List Price: $10.00
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 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?
Re: MS Excel 2002- Specifying a list of valid options for a cell
Answered By: kyrie26-ga on 01 Nov 2002 11:14 PST
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
rated this answer:
Perfect. Exactly what I needed, and quick. Thank you very much.
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at firstname.lastname@example.org with the question ID listed above. Thank you.
|Search Google Answers for|