Use Spreadsheet Compare to find differences between two Excel workbooks.

On the Start screen, click Spreadsheet Compare. If you do not see a Spreadsheet Compare option, begin typing the words Spreadsheet Compare, and then select its option. In addition to Spreadsheet Compare, you'll also find the companion program for Access – Microsoft Database Compare.

Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell. Spreadsheet Compare can detect and highlight just the type of differences you specify.

Suppose the design of your Microsoft Access desktop database has changed (new or modified tables, queries, field properties, forms, or reports) and you want to see a history of these changes. You can use Database Compare to compare the one version of an Access desktop database to another.

Use Database Compare to find design changes between two Access desktop database files or two versions of the same file. Database Compare alerts you to additions, deletions, or renaming of objects such as tables, queries, forms, reports, and VBA modules.

Use Database Compare to compare two Access desktop databases to see the differences between table, query, report, and object design, VBA code, and more. Note: You can't use the Database Compare tool with Access web apps. Read the following articles for more information and step-by-step procedures.

使用試算表比較尋找兩個 Excel 活頁簿之間的差異。

“ 比较文件 ”命令让您能够在两个工作簿之间逐个查看单元格的差异。 您需要在 Excel 中打开两个工作簿才能运行此命令。 结果将按内容种类进行彩色编码，如输入值、公式、命名区域和格式。 甚至有一个窗口可逐行显示 VBA 代码的更改。 单元格之间的差异以如下所示的易于阅读的网格布局显示： “ 比较文件 ”命令使用 Microsoft Spreadsheet Compare 来比较两个文件。 在 Windows 8 中，您可以通过单击“ 应用 ”屏幕上的“ Spreadsheet Compare ”在 Excel 外部启动 Spreadsheet Compare。