How to mark column as Key in Excel file

xlCompare is an Excel file comparison tool that allows you to compare sheets by key columns. This is an important option, that is required to get accurate comparison results.

So, how to mark column as a Key on the Excel worksheet?

  1. Select the column you need in the worksheet panel
  2. Right click on the heading
  3. Mark it as Key in the context menu by selecting the Key Column option
mark column as key on the worksheet

Visual Indication on the worksheet

xlCompare displays a Key icon in the column heading and highlights background in all cells with a color.
Primary Keys columns are easily identified on the worksheet among other ones.