not sure if i'm using the right thing

[Tiffany]

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.

 

[Pete_UK]

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

 

[Peo Sjoblom]

Without knowing too much what you want I would suggest select all the
tables, then do data>filter>autofilter
That will create the dropdowns and you can select items or create custom
filtering like a certain date range etc.

Post back if that isn't what you want

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

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

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

 

[Tiffany]

fabulous thank you so much!