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. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Office for business Microsoft 365 admin More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |