In addition to comparing contents of worksheets, you can use Spreadsheet Compare to check for differences in VBA (Visual Basic for Applications) code. This trail can help you find and correct mistakes before the auditors find them.

You need a trail for your critical workbooks that shows the changes month over month or year over year. Say your organization is due to be audited. To show cell formatting from the workbook, click Home > Show Workbook Colors. Click Home > Export Results.Ĭlick Home > Copy Results to Clipboard to copy and paste the results to another program. You can export the results to an easier to read Excel file. There's also an option for getting a high-fidelity look at each worksheet that shows the cell formatting, close to what you'd see it in Excel. If you want to save your results or analyze them elsewhere, you can export them to an Excel file or copy and paste them into in another program, such as Microsoft Word. Other ways to work with the comparison results 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. If the cells are too narrow to show the cell contents, click Resize Cells to Fit.ĭifferences are highlighted with a cell fill color or text font color, depending on the type of difference.

If a worksheet is hidden in a workbook, it's still shown and compared in Spreadsheet Compare.

In the side-by-side grid, a worksheet for each file is compared to the worksheet in the other file, beginning with the leftmost worksheet in each. 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' file you chose and the workbook on the right corresponds to the 'To' file. The results of the comparison appear in a two-pane grid. Learn more about how passwords and Spreadsheet Compare work together.

Note: If you get an 'Unable to open workbook' message, this might mean a workbook is password protected.

Compare office 2019 versions