Hide and ignore columns
You don't need some columns on your worksheet to be compared?
Select the worksheet (left or right) and click the Edit Columns command on the Ribbon.

This window displays all the columns in your table. Here you can:
- Mark column as key
- Link column with column from the other sheet
- Mark column as ignored (visible, but not included into the comparison)
- Hide or show specific column
By default, xlCompare ignores hidden columns. You can change this in the options.