anything in Excel...

It's Excel-o-lozy...

Solution to apply "Auto filter" on Multiple sheets al-together in Excel.

www.Excelolozy.com - Applying filter on multiple sheets is a big time saver. How? Check here.

"TabManager" can do it.

Do as follows:

  • Open "TabManager"
  • Select the Sheets from list on which “Auto Filter” is to be appliedNOTE : Make sure header row or full data of the table is selected in all sheets.
  • Go to "Apply"...
  • Click "Filter"

and job is done…

Filter will be applied on all selected sheets.

Cool trick...

to get TabManager click here.

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