Inserting Fileter

[kiran]

Hi All,
Is it possible to have 2 filter in same sheet i mean i want to applay filter
to column A,B & C and D,E column left blank & G, H to have filter can any one
help me on this

 

[JulieD]

Hi kiran

according to Help (ver 2003)

"You can apply filters to only one range on a worksheet at a time"

so i don't think it is possible.

Regards
JulieD

 

[Dave Peterson]

The filter arrows will all be in the same row???

You can apply the filter to A:H and hide the arrow in column F if you run a
little macro.

Debra Dalgleish has some sample code at:
http://www.contextures.com/xlautofilter03.html#Hide