Interpreting the Results
If we leave the filter options as default we’re going to see a number of differences between the two sample sheets. As you can see by the color coding, each type of difference will be colored differently. Green values were manually entered, calculated values are blue and formulas are purple.
If we only want to see differences between entered values, we can deselect the filters for the other options (Figure 4).
The results list section will specify the exact differences between the two sheets. As we can see, the details are listed in easy to read form (Figure 5). For example, the compare tool noticed that one of my formulas was different between the two sheets while in two rows I had actually deleted the formula.
You can export the results to a new spreadsheet for or copy the results to a clipboard using the corresponding buttons in the main menu.
Note that the Spreadsheet Compare tool is read-only. It does not let you modify the content of your spreadsheets, so be sure to save the results to a new file if you want to track the differences.
That’s all there is to the Spreadsheet compare tool. It’s easy to use, but for frequent users of Spreadsheets this tool could be a huge timesaver – especially for comparing huge spreadsheets.