Add a Reverse Selection option
Often I apply a filter for say 10 of the 25 items to analyse.
The next thing I want to do is filter for the not yet filtered items (so the other 15 out of 25 items).
Now I have to do this manually.
I really like the Reverse Selection option (like in Windows Explorer) to be added to Excel.
In the attached file I added a screendump of Windows Explorer with this option but this is in Dutch. I think in English the commands are Select All, Select Nothing and Reverse Selection.
Here's another scenario: I often find myself looking through dozens (or hundreds) of items in the filter, then finding the option I was looking for, and then realizing that I should have first cleared all items to be able to select this item only - so I have to go back to clear all and start the search again - extremely annoying. A REVERSE SELECTION option would enable me to de-select the item once I found it, and then reverse selection so the this item now is the only one selected.
The english command is actually 'Invert selection'.