Office & Productivity Software forum

General discussion

Excel 2002 drop down list question.

by Berfert / July 22, 2004 2:47 AM PDT

How do you create a drop down list of a select number of values in excel?

for example I want a user to select when they want a certain task completed. If spreadsheet was left blank I would get all kinds of invalid data. If I supply a drop down list of answers such as Monday, Tuesday, Wednesday, etc... then I would only get those answers back.

I know that you start with an unused column and add the values wanted in the list there but I can't figure out how to get the drop down created back in the column I want and have it show the values I want.

Using WinXP but I don't think the OS matters with this question.

Discussion is locked
You are posting a reply to: Excel 2002 drop down list question.
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Excel 2002 drop down list question.
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Re: Excel 2002 drop down list question.
by KevinTo / August 2, 2004 9:53 AM PDT

Have you tried the AutoFilter feature? It's under Data-Filter. First, highlight the whole document, not just the column to be filtered, then click on Data-Filter-AutoFilter and then "bang", it gives you a tiny down-arrow. Hope this helps.

Collapse -
Re: Excel 2002 drop down list question.
by Kees Bakker / August 3, 2004 4:19 AM PDT

Although I didn't try it on my Excel 97, I'm sure you'll find a very clear tutorial for what you want.

This, in fact, was the first hit on a google search for excel drop-down box. Let me stress that Internet is an excellent source for tips and tricks and coding samples for MS Office.


Popular Forums
Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions

The Samsung RF23M8090SG

One of the best French door fridges we've tested

A good-looking fridge with useful features like an auto-filling water pitcher and a temperature-adjustable "FlexZone" drawer. It was a near-flawless performer in our cooling tests.