Compare formulas with Spreadsheet Compare

Important:  Spreadsheet Compare is only available with Office Professional Plus 2013 or Office 365 ProPlus.

After you've run a spreadsheet comparison in Microsoft Spreadsheet Compare, you can quickly see the underlying formulas for cells shown in the comparison grid. Do this by choosing the Show Formulas button.

Results shown

Here, the formulas are shown in their cells, instead of the results of the formulas. In the image above, cell A1 shows the date, 3/15/2012, but in the image below, the formula =TODAY() is shown. This can make it easier to compare formulas side-by-side from different workbooks to find subtle changes.

Formulas shown

Choose Show Formulas again to switch back to showing the results of the formulas.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!