Select Row Differences

Using the Select Row Differences Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut selects all cells that do not match the value in the active cell in a row or selection within a row.
Other useful Select Special keyboard shortcuts