www.Excelolozy.com - Simple, select Excel sheets on which filter is to be applied, then Apply filter.
You might be thinking this and I ll say no.
It's true that what ever we do on Active sheet, same is applied on all Selected sheet...
BUT this is not the case with "Auto Filter"...
Auto Filter is applied only on Active Sheet and not all selected tabs.
Is it possible in Excel directly by default?
Answer is NO.
BUT yesss, indirectly it is possible...
HOW??? wait for my next post...
Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com
You might be thinking this and I ll say no.
It's true that what ever we do on Active sheet, same is applied on all Selected sheet...
BUT this is not the case with "Auto Filter"...
Auto Filter is applied only on Active Sheet and not all selected tabs.
Is it possible in Excel directly by default?
Answer is NO.
BUT yesss, indirectly it is possible...
HOW??? wait for my next post...
Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com