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.
0 kommentar(er)
