M
Muskrat24
Can I have more than one filter if I have several categories on a sheet that
i want different filters for, if so how.
Thanks
i want different filters for, if so how.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elgee
Are you familiar with the Data --> Filter option?
Are you trying to filter more than 1 column? Have you tried the "custom"
filter?
Am I interpreting your question correctly?
Are you trying to filter more than 1 column? Have you tried the "custom"
filter?
Am I interpreting your question correctly?
M
Muskrat24
no I have multiple categories on a sheet with several selections for each
and I want a filter for each category. The only way that i can think of to do
this is to have a filter for each category but it will only let me have 1
filter per sheet. Is there a way i can have more than 1 filter?
and I want a filter for each category. The only way that i can think of to do
this is to have a filter for each category but it will only let me have 1
filter per sheet. Is there a way i can have more than 1 filter?
G
Gord Dibben
I believe you can have more than one advanced filter on a sheet.
You can't have more than one autofilter section.
Gord Dibben MS Excel MVP
You can't have more than one autofilter section.
Gord Dibben MS Excel MVP
M
Muskrat24
how do i use an advanced filter?
Gord Dibben said:I believe you can have more than one advanced filter on a sheet.
You can't have more than one autofilter section.
Gord Dibben MS Excel MVP
G
Gord Dibben
You could start with Excel help on advanced filter.
Or see Debra Dalglesih's site for instructions on the basics.
http://www.contextures.on.ca/xladvfilter01.html
Gord
Or see Debra Dalglesih's site for instructions on the basics.
http://www.contextures.on.ca/xladvfilter01.html
Gord