If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
not sure if i'm using the right thing
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. |
#2
|
|||
|
|||
not sure if i'm using the right thing
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. |
#3
|
|||
|
|||
not sure if i'm using the right thing
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. |
#4
|
|||
|
|||
not sure if i'm using the right thing
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. |
#5
|
|||
|
|||
not sure if i'm using the right thing
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. |
Thread Tools | |
Display Modes | |
|
|