Select Column Differences

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