filter view: place filter text box above a filtered list to easily show what a spreadsheet is filtered to
I have a spreadsheet which I'm filtering (i know I could use a pivot table but in this case that's not what I want).
Every time I want to add a filter item I click the filter down arrow, which opens a text box and a series of values with checkboxes to add or remove these.
When we make a list filtered, could you please add a box, perhaps above the filter line, that shows what that column is filtering to? Perhaps this box could also be used instead of having to click the down arrow to open the filter options: just type it directly into the box instead?
This would make filtering easier because we could see at a glance what we are filtering down to, and would make filtering a list more efficient.