Excel – Filters on Multiple Tables in One Sheet

If you are an Excel head and you use filters in your table to lookup data, you might get upset because you only can have one table per sheet to filter. Well not anymore! If you define your tables, well, as tables then you can have more than one table with perk of filter for each table in one sheet.

Tip: remove table style to maintain your styling 

and here you go …