EXCELL, an arrow next to a title, to select a citeria 2

[pssheba]

Hi !
I'd like someone to explain me something but i dont know what it is.
An excel sheet is made of, say , 4 columns. Column 1 lists names of companies. Column 2: products. Column 3 location and 4th: price.
Near the first cell of each column, there is an arrow situated next to the title. Pressed, the list box displays all the possible criterias in that particular column. If i select a product "Shoes" for example, column 1 will list only companies that produce Shoes. If i select "Mercedes" from column 1 (having pressed the arrow) then col 2 will show "Cars" from the products list.
I wish to create that on my Excel page but i dont know what it is called and how to do that.
Could any one Please instruct me of how it is done and what it is called ?
Thanks !

 

[xlhelp]

That's Autofilter. You can turn it on or off by going to Data, Filter, AutoFilter. Make sure the first row contains names for the columns

Member- AAAA Association Against Acronym Abusers

 

[AnotherHiggins]

Data > Filter > Auto Filter

Have fun!

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[pssheba]

Thank you so much fellows ! I thought i'd need a week's time to learn it....