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]
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
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
I need this! Is very important
I NEED TO DO THIS ALL THE TIME!!!!!!
Yes and also put #N/A and blanks at the top of the list!
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!
I WANT TO DO THIS ALL THE TIME!!!
Excelente ! Muito bom !
Você é lindo !
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.
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)