[SOLVED] Adding sort filters to multiple selected columns

johnlovesbeer · #1 11-14-2009, 05:58 AM

Hi all.
I have a row of sub-headings at row 12 that require Sort Filters. My problem is that I need the filters on selected columns only. It seems that with the standard filter button I get all or nothing. I hope someone can enlighten me!

JLB.

DonkeyOte · #2 11-14-2009, 06:15 AM

Filters (AFAIK) can not be applied to more than one range and that range must obviously be contiguous.

johnlovesbeer · #3 11-14-2009, 06:36 AM

Thanks Donkeyote for the reply. I may not have explained myself properly. At the moment I have the required sort filters on columns A to E but I also need sort filters on columns AB and AE but not the columns between. Can this be done?
Cheers,
JLB.

DonkeyOte · #4 11-14-2009, 06:41 AM

No.

To reiterate the earlier point to avoid confusion - filters can be applied only to a single contiguous range - ie if A:E are filtered you can not apply another separate filter on the same sheet without first removing the filter on A:E.

(and again this is a "AFAIK")

**teylyn** · #5 11-14-2009, 06:47 AM

Me believes in XL 2007 you can create several tables per worksheet. You may want to get rid of the default table formatting to avoid see-sickness, but you then have, in effect, separate areas of the worksheet that can be sorted independently.

Select the first range - click Insert ribbon, Table

Select the second range - click Insert ribbon, Table

viola! Filters and all!

DonkeyOte · #6 11-14-2009, 07:00 AM

An excellent suggestion Teylyn, I did not think of that and that will work for Sorting each table independently !

(of course filtering as opposed to sorting on any given Table will affect row visibility of the entire row regardless)

**teylyn** · #7 11-14-2009, 07:03 AM

well, you can still filter on one table, you just need to remember to make all records visible on the other tables first and vice versa!

DonkeyOte · #8 11-14-2009, 07:04 AM

Yes, I was just making the point that although sort feature is table independent filtering is not.

johnlovesbeer · #9 11-22-2009, 04:12 AM

Thanks, you guys rock!

JLB

Welcome to the Excel Forum

Forum Statistics