Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel 2002 drop down list question.

Jul 22, 2004 2:47AM 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

- Collapse -
Re: Excel 2002 drop down list question.
Aug 2, 2004 9:53AM 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.
Aug 3, 2004 4:19AM PDT

Although I didn't try it on my Excel 97, I'm sure you'll find http://spreadsheets.about.com/library/weekly/blexdropboxes.htm 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.

Kees