![]() ![]() From the Inquire tab, you can analyze a workbook, see relationships between cells, worksheets, and other workbooks, and clean excess formatting from a worksheet. In addition to the comparison features of Spreadsheet Compare, Excel 2013 has an Inquire add-in you can turn on that makes an "Inquire" tab available. If the cells are too narrow to show the cell contents, click Resize Cells to Fit. When the workbook was updated, the formula in F5 was corrected so that it's now =SUM(B5:E5). The calculated result in cell F5 also changed, but the more important reason is that in the earlier version its formula was incorrect (it summed only B5:D5, omitting the value for Q4). Because those values changed, the calculated results in the YTD column also changed – cells F2:F4 and E6:F6 have a blue-green fill that means the calculated value changed. In the comparison results, cells E2:E5 in both versions have a green fill that means an entered value has changed. The latest version of the workbook contains the final numbers in the E column for Q4. In the example shown here, results for Q4 in the earlier version weren't final. The lower-left pane is a legend that shows what the colors mean. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list. Note: Even if a worksheet is hidden, it's still compared and shown in the results.ĭifferences are highlighted with a cell fill color or text font color, depending on the type of difference. If there are multiple worksheets, they're available by clicking the forward and back buttons on the horizontal scroll bar. In the side-by-side grid, a worksheet for each file is compared to the worksheet in the other file. Changes are highlighted by color, depending on the kind of change. Details appear in a pane below the two grids. The workbook on the left corresponds to the "Compare" (typically older) file you chose and the workbook on the right corresponds to the "To" (typically newer) file. The results of the comparison appear in a two-pane grid. Learn more about how passwords and Spreadsheet Compare work together. Click OK and then enter the workbook's password. If you get an "Unable to open workbook" message, this might mean one of the workbooks is password protected. In the left pane, choose the options you want to see in the results of the workbook comparison by checking or unchecking the options, such as Formulas, Macros, or Cell Format. Tip: You can compare two files with the same name if they're saved in different folders. In addition to files saved on your computer or on a network, you can enter a web address to a site where your workbooks are saved.Ĭlick the green folder icon next to the To box to browse to the location of the workbook that you want to compare to the earlier version, and then click OK. Compare two Excel workbooksĬlick the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook. It also requires Office Professional Plus versions or Microsoft 365 Apps for enterprise. In addition to Spreadsheet Compare, you'll also find the companion program for Access – Microsoft Database Compare. If you do not see a Spreadsheet Compare option, begin typing the words Spreadsheet Compare, and then select its option. On the Start screen, click Spreadsheet Compare. Tip: You can export the results to a spreadsheet or copy to the clipboard to paste into another document.Important: Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional Plus 2016, Office Professional Plus 2019, or Microsoft 365 Apps for enterprise. You can also choose what types of changes you want to see from 14 different options, like formulas and macros. If you navigate to a change in one spreadsheet, the other spreadsheet moves to the same location. The compared spreadsheets will display on a split-screen. This makes seeing and understanding the changes easier. Whereas some applications output an Excel comparison report to PDF, compareDocs outputs the differences to an Excel viewer. Load the Original and Modified Excel spreadsheets into compareDocs.Ģ. This means you can expect a faster and more accurate comparison report. It compares Excel files natively, meaning no conversion is required. Some document comparison applications convert Excel files to PDF as part of the comparison process. Fortunately, compareDocs supports native Excel comparisons, so you can quickly and accurately compare spreadsheets for changes. But it becomes nearly impossible when it involves two Excel spreadsheets full of calculations and formulas. Searching the contents of a document to see what’s changed isn’t an easy task at the best of times. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |