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.

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.

Without knowing too much what you want I would suggest select all the
tables, then do datafilterautofilter
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

"Tiffany" wrote in message
...
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.

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.

fabulous thank you so much!

"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.