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" <[email protected]> wrote in message
news:[email protected]...
> 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