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

G

Guest

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?
 
G

Guest

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

Debra Dalgleish

You can have only one AutoFilter per sheet.

So, you can select all the data, in all the sections, and choose
Data>Filter>AutoFilter. 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.
 
G

Gord Dibben

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
 

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

Excel Limit to Named Ranges 1
MULTIPLE PRINT AREA 3
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Multiple Instances in a Column 1
Can you have mulitple drop boxes on 1 worksheet? 2
Multiple Use Of Auto Filter 1
Auto Filter Multiple Criteria 1
auto filter on multiple rows 1

Top