The changes are highlighted by color, depending on the kind of change. The workbook on the right corresponds to the "To" file you have chosen.ĭetails of changes in workbook-To as compared to Workbook-Compare appear in a pane below these two grids.The workbook on the left corresponds to the "Compare" file you have chosen.The results of the comparison appear in a two-pane grid − The order of Files in Compare and To gets changed. If the order is not OK, click Swap Files. Check if the order of Files in Compare and To is OK.Only the workbooks that are open will be displayed.If any File name that is displayed is not the one you wanted, click the down-arrow next to that File name.Check the file names displayed in the boxes next to Compare and To.The Select Files To Compare dialog box appears.Click on Compare Files in the Compare group.Open two workbooks that you want to compare.You can compare two workbooks cell by cell and find the differences, if any, in terms of changes in the second workbook as compared to the first.
You will find the INQUIRE tab on the Ribbon.Ĭlick the INQUIRE tab.
If you find the INQUIRE tab on the Ribbon, you can skip to the next section.
0 kommentar(er)
