Adding sort filters to multiple selected columns

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.

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

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")

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!

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)

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!

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