How do I auto-filter multiple ranges on one worksheet?
 

I have multiple section that I'm to keep track of. I have entered all the
data for each section on one worksheet. I now need to be able to filter each
section. I am able to set up auto-filter on one section but am not sure how
or if I can set it up for each section or multiple ranges.

Any advice?

Select the row containing the field names (Column headers) then go to Data -
Filter- auto Filter

"AREV" wrote:

I have multiple section that I'm to keep track of. I have entered all the
data for each section on one worksheet. I now need to be able to filter each
section. I am able to set up auto-filter on one section but am not sure how
or if I can set it up for each section or multiple ranges.

Any advice?

You can have only one AutoFilter per sheet.

So, you can select all the data, in all the sections, and choose
DataFilterAutoFilter. That would apply one AutoFilter to the selected
range. If you filter on any of the columns, the entire sheet will be
affected.

Or, put each section on a separate sheet, and you'll be able to filter
each section separately.

AREV wrote:
I have multiple section that I'm to keep track of. I have entered all the
data for each section on one worksheet. I now need to be able to filter each
section. I am able to set up auto-filter on one section but am not sure how
or if I can set it up for each section or multiple ranges.

Any advice?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If you insert a couple of blank rows between each section you can filter just
the section between blank rows.

You cannot filter columns separately.


Gord Dibben Excel MVP

On Mon, 14 Feb 2005 09:57:01 -0800, "AREV"
wrote:

I have multiple section that I'm to keep track of. I have entered all the
data for each section on one worksheet. I now need to be able to filter each
section. I am able to set up auto-filter on one section but am not sure how
or if I can set it up for each section or multiple ranges.

Any advice?