Allow saving filters
As a biz user, we filter sheets all the time ... and very often run through switching filters repeatedly. I mean that given a multiple columns, we might filter a few columns to see what the data says then someone else using the sheet may filter differently, and then we want to return to the original set of filters.
The feature request is to save a snapshot of the filter choices with a name, so that users can prepare several combinations of filters and switch between them easily.
This is particularly useful when the underlying data changes.
Essentially, as a MS Access user I do this alot with my sets of queries that I can run anytime, but many users are not MS Access savy and I see alot of wasted time for these users painstakingly setting filters repeatedly.
If you are using AutoFilters for your filters, check out “Custom Views” which are accessible on the View ribbon, and allow you to save your filter settings.
1 commentComments are closed
Kenneth Barber commented
As an alternative, add 1 column to your table for every set of filter settings that you want to save. Write a formula for each new column that evaluates to either TRUE or FALSE based on your filter conditions. Then you just filter this single column for TRUE rather than filter many columns.