How to use multiple autofilters?

**c4outlaws** · 09-14-2011, 03:54 PM

Hi, I am new to the site. I also am fairly new to Microsoft Excel 2003. As you can see is the photo, there are 3 groups of data. I can apply autofilter to 1 group but how can I apply autofilter to all 3 at the same time?

**TMS** · 09-14-2011, 03:57 PM

You can't. You can select all the data and apply an Autofilter which you can use across the whole sheet.

Regards

**c4outlaws** · 09-14-2011, 04:02 PM

Is the any way at all to make each group sortable as separate groups?

**TMS** · 09-14-2011, 04:05 PM

You can manually select each group of data (rows) and sort it, making sure you don't extend the selection.

Regards

**c4outlaws** · 09-14-2011, 04:13 PM

hmm....newer versions of excel allow multiple auto filters? what is advanced filter? can that help in my situation? I appreciate your help.

**mlandrie** · 09-14-2011, 04:40 PM

Why don't you try separating the data onto three different worksheets and sorting them individually? Unless you need to see all of the data to compare... then I would suggest making a different column for each heading... and for those that it does not apply, use "N/A" or leave blank. Then you can sort everyone together. Hope this makes sense... I've attached an example of the before and after; sorry for the crudeness. If you'll attach the actual workbook instead of a screenshot, it'd help!

**c4outlaws** · 09-15-2011, 08:48 AM

It totally makes sense. I was just hoping to keep all the team data on 1 worksheet but be able to sort the 3 tables separately. That way it I could sort all the D separate from the C, LW and RW. Vice-versa with the sorting the C, LW and RW as one gruop separate from the rest. I have attached the workbook.

(C, LW and RW are combined as a group)