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