Select key columns and headings

If you are going to compare two tables, you need to know about key columns and headings. Key columns define a set of values, that identify every row in your table. This could be SKU, TAXID, Name, Property Address, ... Heading rows is a part of your table that defines structure. Typically, this is a row with a list of field names.

In the simple example below, the key column is Fruit and heading is first row.

Right click on the column heading and select Key Column in the context menu. To clear key column - do the right click again and click the Standard Column item in the menu.

Right click on the row heading area and click the Heading Row item in the menu.

Key columns and Heading rows are highighlited with background color on the worksheet.