How To Compare Two Columns And Find Differences In Excel

To find the differences between two columns of data in a Microsoft Excel spreadsheet, select your version of Excel, and follow the instructions.

Microsoft Excel for Office 365

Open the Excel spreadsheet containing the data you would like to compare.
Select all the cells in both columns containing the data to be compared.
How to select one or more cells in a spreadsheet program.
In the Ribbon, on the Home tab, find the Editing section and click Find & Select.
In the drop-down menu, select Go To Special.
Microsoft Excel for Office 365.
Microsoft Excel 2007 & 2010.
Microsoft Excel 2003.
In the Go To Special pop-up window, click Row differences, then click OK. Excel selects the differences between the two columns.
To highlight these differences, leave them selected, and click the paint bucket icon in the font menu and select the color you want to use. Similarly, you can right-click and select the paint bucket to highlight the cells.

In the Ribbon, on the Home tab, go to Find & Select, then click Go To.
In the Go To pop-up window, click Row differences, then click OK. Excel selects the difference between the two columns.
To highlight these differences, leave them selected, and click the paint bucket icon in the font menu and select the color you want to use. Similarly, you can right-click and select the paint bucket to highlight the cells.

In the file menu at the top of the program window, click Edit and select Go To.
In the Go To Special pop-up window, click Row differences, then click OK. Excel selects the difference between the two columns.
To highlight these differences, leave them selected, and click the paint bucket icon in the font menu and select the color you want to use. Similarly, you can right-click and select the paint bucket to highlight the cells.

You can use the shortcut Ctrl+G, then click Special to open the Go To menu. Alternatively, press F5, then click Special on the pop-up screen.