Compare In Excel Two Columns

Steps to compare two columns in Excel

• Step 1: Select the two columns you want to compare by highlighting both ranges side by side.
• Step 2: Press Ctrl + \ on your keyboard to highlight cells in the first column that are different from the corresponding cells in the second column.

Result: Excel will highlight the cells with mismatched values in a darker shade for easy comparison.

Tip: This shortcut only works when comparing two columns of equal length. For more advanced comparisons, consider using =A1=B1 in a helper column.