Select Column Differences | ExcelTraining.com

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.

Discover 242 Excel Keyboard Shortcuts for Windows and Mac

Other useful Select Special keyboard shortcuts

Display "Go To" Dialog Box

Select Cells With Comments

Select Row Differences

Select Current Region

Select Current Array