Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting a row | Excel Discussion (Misc queries) | |||
Inserting worksheet in Word | Excel Discussion (Misc queries) | |||
Inserting comments on graphs | Excel Discussion (Misc queries) | |||
Copy an IF function when Inserting new row | Excel Discussion (Misc queries) | |||
Can I retain functions from a previous cell when inserting a new r | Excel Discussion (Misc queries) |