Multiple Filters Across One Sheet

Question

Hi there, I need some help with applying filters to a particular workbook.

I need all the accumulated data to be on one sheet so I need to separate out the tables and apply filters to each one.

In the below snip I have two tables. The top one has a filter applied under the advisors and I want the one beneath it to be able to have that too. Excel won't let me apply  filter to more than one table at a time and I can't seem to remember how to get around this issue. Is anyone able to help?

Answer 1

Ciao,

what you should do is:

1. Remove all filters
2. Select of the cells in the above table
3. Click in "Insert" tab, then "Table"
4. Repeat 2) and 3) for the below table

Then you'd be able to do so. Please let us know.

Thanks

Ugo

Answer 2

Perfect, thanks Ugo.