873764_en-US

liliconcom

Select all NOT matching

I often need to select all NOT matching to hide or hide/exclude, and have to do two steps, Select All, then Invert Selection.

 

What is the improvement you would like to see?  Have the ability to Select All Not Matching in the context menu when you right click either the cell or row state column

 

It's a 'nice to have', certainly not that critical

 

 

Basic Data Analysis and ModelingRe: Select all NOT matching

To facilitate the "invert":
I have the same issue five times a day, and I always come to the same conclusion: it's nice to have a shortcut.
I enjoy using it every time.

if you have a Windows system, please have a look at Quickselect+Toolbar - it provides the "invert row selection" at a single mouse click:

 

For Mac, you could link the command to a keyboard shortcut.

Re: Select all NOT matching - Status changed to: Acknowledged

Thank you for this request, and for @hogi suggestion in the comments!