The Compare Files command uses Microsoft Spreadsheet Compare to compare the two files. Differences between cells are shown in an easy to read grid layout, like this: There's even a window that can show VBA code changes line by line. Results are color coded by the kind of content, such as entered values, formulas, named ranges, and formats. You need to have two workbooks open in Excel to run this command. The Compare Files command lets you see the differences, cell by cell, between two workbooks. If you don't see the Inquire tab in the Excel ribbon, see Turn on the Spreadsheet Inquire add-in. The Inquire tab on the Excel ribbon has buttons for the commands described below. You can use the commands in the Inquire tab to do all these tasks, and more. If Microsoft Microsoft 365 or Office Professional Plus 2013 is installed on your computer, the Spreadsheet Inquire add-in is available in Excel. Say you want to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbooks or worksheets.
0 Comments
Leave a Reply. |