Have you ever used the Custom Views button on the View tab of The Ribbon in Excel? No me neither until I discovered that it can be used to save and re-apply filter criteria.

I’m not talking about the =FILTER() function. I’m talking about the filter arrows that appear on the right hand side of the headings in a Table or list.

Unfortunately Custom Views are not compatible with Tables (WHAAAT??) so if your data is in a Table you’ll need to convert it back to a standard Range.

But if you’re OK doing that (yes I know it goes against everything I’ve said about how wonderful Tables are) it means that you can save often-used filter criteria and quickly re-apply it with a couple of clicks!

Interested? Watch this video