Inserting Fileter
 

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

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

"kiran" wrote in message
...
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

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

kiran wrote:

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

--

Dave Peterson