anything in Excel...

It's Excel-o-lozy...

Filter all sheets in excel in one go - Apply Auto filter on Multiple sheets in Excel

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