Filters

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
 
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?
 
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?
 
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
 
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I filter by something not in a field 1
Pivot Tables/Charts and common filter 1
Linking PivotTable Fields - Excel 2007 1
Dissect a file into several sheets or files 3
custom text filters? 1
Aligning Colour Scheme Across Workbook 0
Grouping Dates in Excel 2007 Pivot Tables 1
filter within a filter 1

Top