haaace.blogg.se

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. In Excel Options window, click on Add-Ins.If you do not find the INQUIRE tab on the Ribbon, make the Inquire Add-in active. If you find the INQUIRE tab on the Ribbon, you can skip to the next section. Analyze a workbook for problems or inconsistencies.