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.
Stephen Dragoni commented
This is my number 1 wish in Excel.
Liam Costello commented
Further to John’s to the point response, if you’re dealing with large data files the last thing you’d want to do is add resource robbing formatting.
John Powell commented
Anurag - what you propose is a workaround and in certain cases it might be worth all the extra clicks required however what the EXCEL user community is asking for is a single click "INVERT FILTER" capability. We want to "Invert Filter" like a toggle with one click from the filter drop down menu.
ANURAG SINGH commented
HERE I M TO HELP YOU
FILTER THAT ROWS AND THEN COLOR IT (YELLOW, RED OR YOUR FAVORITE COLOR)
THEN REMOVE FILTER BY PRESSING (CTRL+SHIFT+L) THEN AGAIN TURN ON FILTER BY PRESSING (CTRL+SHIFT+L) AND IN ANY COLUMN AND SELECT FILTER BY COLOR IN CELL DROP DOWN MENU THEN SELECT "NO FILL"
Florian Mair commented
Gianni Braccioforte commented
Select one column and set a background color (for example Green), then in the filter, filter for color "no color" :-)
I second this!
Would be great if it worked on multiple criteria at once, no?
I NEED IT ASAP!!!!
Ulisses Silva commented
Como isso ainda não existe?
Joel D commented
Great idea! I've thought of this for a while - glad to see some support for it.
Neo Anderson commented
This is a MUST feature!
Gary Knott commented
There is a way to invert a filter, see "Remove current selection from data filter" here
When I apply the filter with the first selection, I usually add an additional column (that I name filter for example) and I type "A" into all of the cells within the selection.
Next, I disable filter and I hit filter again. This time, I do it using the new column, where I can choose to select A or "blank". I select Blank, and voilà!
Filter out #N/A, in the next column copy #N/A column as values. Remove the #N/A filter and then filter Blanks from the next column where you previously copied #N/A. This can be used to achieve desired result of inverting filter.
Would save masses of time with large spreadsheets. Like there is an option to add to the selection would also help if there was an option to keep subtracting on this invert logic. Totally agree with #N/A and blanks at the top of the list too.
Yes yes yes !!! do it .. i dont understand why we still dont have it ..
Do it before someone else comes with a better product and a org. which listens .. and you guys will be broke