Invert Filter Selection
I'd like to see an option to invert filter selections. For example: If i apply a filter in a table i can select some boxes with a tickmark, but if i want to invert my selection i need to unmark selected itens before and mark the others.
In resume, i'd like to invert itens selected in a filter for the others unmarked.
Thanks for this suggestion. We agree it would be a nice improvement. We will consider this for a future update.
Steve [Microsoft Excel]
51 comments
-
Moch. Tomy Damastha
commented
hi guys, i was so confused while invert any coloumn filtered. i create new sheet and move the filtered table, on base sheet i coloring coloumn then filter with "nofill" it works but lame
-
Anonymous
commented
Agreed. This would make my life a lot easier!
-
James MacAdie
commented
I've writen a VBA solution to this, which should tide us over until MS offers this as native functionality. I posted the code on stack overflow: https://stackoverflow.com/questions/48423684/invert-filter-selection-in-excel
-
Anonymous
commented
I need this! Is very important
-
Tayo
commented
I NEED TO DO THIS ALL THE TIME!!!!!!
-
Graham
commented
Yes and also put #N/A and blanks at the top of the list!
-
Anonymous
commented
YES!!!! Then the #N/A and blanks can be on the top so you don't have to scroll all the way down every time to find these! This is so basic and is done over and over that's it's amazing this option hasn't been available for years. Or at least just have the #N/A and blanks appear at the top of the list instead of at the bottom....that in itself would be a huge improvement!
-
Anonymous
commented
I WANT TO DO THIS ALL THE TIME!!!
-
Anonymous
commented
Excelente ! Muito bom !
Você é lindo ! -
Jody
commented
Excellent suggestion. In addition to inverting the filter I would also like for the select all option to always remain in view. I tend to get ahead of myself and scroll down to the item I want to filter by and then realize that I needed all the others unchecked first. Of course an invert option would also solve this particular problem but keeping the select all option in view would still be useful.
-
Anonymous
commented
Hi, well the idea is not new at all, and lots of software do handle such a feature, Excel might be a good candidate for that too : when you select cells on a sheet, it could be useful to have a Revert or Invert Selection feature to select all other cells within a sheet (as described here https://www.extendoffice.com/documents/excel/762-excel-reverse-selections.html)