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.

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×