The Problem:

Tables are awesome. They've been around for more than a decade and in all that time Microsoft still hasn't offered anything like Custom Views for Tables.

I sometimes work with large tables where I need to look at various column groupings, specific record groups and various sorts. Custom Views provided a quick and easy way to save and apply sorts, filters, and column settings. But Custom Views turn themselves off when Excel's tables are present. Until now we had to choose Tables or Custom Views. No longer!.

Our Solution:

BXL Views is a free add-in that saves any number of sorts, column settings, and filter settings for each visible table in our workbook, and then re-applies our saved views when needed. Just sort our table, click Save Sort and when we need to reapply that sort simply select it from the Select Sort dropdown. Unlike Custom Views, we can save each setting individually and combine them in any way we want.