Using the Select Column 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 column or selection within a column. This shortcut does depend on the location of the active cell within the selection.
Other useful Select Special keyboard shortcuts