Drop Down list in cell question How'd they do that?

[Spock's Brain]

I have received a spreadsheet & don't know how they did the drop down boxes.

Various cells display a drop-down box with custom lists when clicked. But they did not use a dropdown from the control-toolbox because, among other things, I can't see a control-source list anywhere in the spreadsheet. And there are no macros.
I thought I knew Excel but this is a new one on me.

[Tom Morales]

You may be looking at the autofilter feature. (Tools/Filter/Autofilter).
Tom

[NateO]

I'd put my money on Data Validation. Go to the cell in question and click on Data (Menu)-> Data Validation. If the worksheet isn't protected, you should be able to see the creator's tricks. Incidentally, a neat resource...

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-20 18:57 ]

[Spock's Brain]

Bingo. Data Validation. Very clever. ;O)

[Oyster1967]

Hi Guys,
I want what this guy's got..that is, cells with drop down boxes, you guys call it Data validation..how do I do it?

Cheers
Andrew

[NateO]

Originally Posted by NateO

Go to the cell in question and click on Data (Menu)-> Data Validation.

From there you get a dialog with options, chances are good you want a list.

Here's a Microsoft write-up:

http://support.microsoft.com/kb/211485

Debra's is better:

http://www.contextures.com/xlDataVal01.html

Enjoy!