There are about 100 exel help threads so I'm sorry if this is a repeat. I would like to have a cell that has a finite number of choices, such as you click on the cell and you can pick either cat dog or fish from a list. From there the informantion would change other things in the spreadsheet but I think I have that covered. I have tried the help and serched google but nothing is turning up what I wan to do. Thanks in advance for any help you can give.

2/11/2006 6:04:14 PM

do you need a dropdown box for a user to use? or is this for your own use?

because if you don't, then you can leave a blank cell and then have all your needed choices below it. then right click on the blank cell and select "Pick from drop-down list..." from the popup window

[Edited on February 11, 2006 at 6:14 PM. Reason : .]

2/11/2006 6:09:36 PM

search for drop down list in the help file

2/11/2006 6:12:37 PM

user to use, it isn't going to be used by many people but I would like others to use it without an hour of explaining

2/11/2006 6:13:38 PM

Thanks that worked, I put everything in the search but that.

2/11/2006 6:16:20 PM

do you want an autofilter?

for instance:

Animal    Name      Month     Day
Dog       Kudos     October   9
Dog       Sam       August    4
Cat       Gadget    May       20
Cat       Socks     June      13

2/12/2006 3:07:47 AM