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

On Thu, 18 Jun 2009 14:32:02 -0700, Muskrat24
wrote:

how do i use an advanced filter?

"Gord Dibben" wrote:

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

On Thu, 18 Jun 2009 13:53:01 -0700, Muskrat24
wrote:


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?
"Elgee" wrote:

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?
"Muskrat24" wrote:

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