I find it safer to make sure you select all the data just in case there
might be empty rows in-between
data and if that happens the autofilter won't include the data below the
empty rows

--


Regards,


Peo Sjoblom

"Pete_UK" wrote in message
...
Position your cursor within your data and click on Data | Filter |
Autofilter (to turn it on). This will give you drop-down arrows in the
header cells, and if you click the one for State you will see all the
states listed, together with a few other options like All, Custom etc.
Just click on the State you want, and then all the rows for the other
states will be hidden.

Hope this helps.

Pete

On Sep 19, 3:35 pm, Tiffany wrote:
Hi,

I have a spreadsheet that i have entered all my data and what i would like
to do is creat dropdown menus at the top of each list so that i can easily
sort through all of my information. i.e. if i just want to see information
on a certain state with in my worksheet i would like to be able to go to
the
dropdown menue and choose IL and only see the information that i have for
the
things within IL.

how do i do this? i thought i might need to use a combobox but i'm not
sure.
and if i am how do i make it work for me.