Filter Boxed Colored when Active
When you have a filter box active, can the box be coloured so it is easier to see which columns have filters on them that are active and which are not?
I think the idea you’re asking for is already supported (slightly differently than your suggestion) in current versions of Excel 2016 (or O365).
When you filter an AutoFilter, Table, or PivotTable in current versions, the filter box (we call it the ‘Filter Drop down’) will show both the down arrow, as well as a filter icon in it. You can then look to see what columns have that filter icon in them to know what’s being filtered.
Let me know if you were thinking of something else, or if you’re not seeing that behavior.
PS – in previous versions of Excel, when a filter was applied, the down arrow in the Filter Drop Down would change from black to blue (which we thought was a bit too subtle, so we added the additional icon.
3 commentsComments are closed
The downward arrow is not effective for larger spreadsheets. A coloured icon is a better presentation to a user to easily identify a column is filtered. It should be a simple change to highlight the Filter Icon in a different colour when it is active.
The filter icon looks way too close to the down arrow, so it's hard to distinguish filtered vs. unfiltered columns, especially when you're working in a sheet with lots of columns. Simply highlighting the filter box to a different color would make it so much easier to quickly find filtered columns when you are scrolling across a spreadsheet. This seems like a simple feature that would be well received by anyone that works in Excel.
Brian Hughes commented
the filter icon is too small to see. I work with sheets out to column EM. In the same way that row numbers go blue when a filter is applied, the column headers also showing blue and bolded would be excellent