Compare formulas with Spreadsheet Compare

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.