¿Cómo comparo dos hojas de cálculo de Excel para detectar diferencias en Excel 2007?

How do I compare two Excel spreadsheets for differences in Excel 2007?

Work

1. Introduction.
2. 1Open the two workbooks you want to compare.
3. 2Click the View Side by Side button in the Window group of the View tab.
4. 3Scroll down or across a worksheet.
5. 4(Optional) Click the Synchronous Scrolling button in the Window group if you want to turn off simultaneous scrolling.

Compare 2 Excel workbooks

• Open the workbooks you want to compare.
• Go to the View tab, Window group, and click the View Side by Side button. That’s it!

Select both columns of data that you want to compare. On the Home tab, in the Styles grouping, under the Conditional Formatting drop down choose Highlight Cells Rules, then Duplicate Values. On the Duplicate Values dialog box select the colors you want and click OK. Notice Unique is also a choice.

Click Home > Compare Files. The Compare Files dialog box appears. 2. Click the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook. 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.

Select a cell where you want to insert a hyperlink. Right-click on the cell and choose the Hyperlink option from the context menu. The Insert Hyperlink dialog window appears on the screen. Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.

To access the Spreadsheet Compare Add In, click on the Windows icon in the lower left of your task bar, and search for Spreadsheet Compare. You will be taken to a sort of mission control for comparing spreadsheets.

Compare two sheets in same workbook 1 Open your Excel file, go to the View tab > Window group, and click the New Window button. 2 This will open the same Excel file in a different window. 3 Enable View Side by Side mode by clicking the corresponding button on the ribbon. 4 Select sheet 1 in the first window and sheet 2 in the second window.

Highlight differences between 2 sheets with conditional formatting. To highlight cells that have different values in two sheets with the color of your choosing, use the Excel conditional formatting feature: In the worksheet where you want to highlight differences, select all used cells.

Your worksheets should have the same layout and structure including grouping, filtering, and sorting. For example, we consider the rows order when comparing sheets, so sheets with different sorting order will most likely be perceived as completely different.

It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.