To compare Excel spreadsheets - method 1
- First, open both the Excel tables.
- Now paste the contents of the first table into the second table. To do this, select all the data with the key combination [CTRL]+[A] copy of the table with [Ctrl]+[C] and then paste at the end of the second data set with [Ctrl]+[V].
- Now double entries in the filter, first select the appropriate column.
- Under the tab "data" you find the Button "remove duplicates". The Tool searches the selected column for duplicates and removes multiple entries automatically.
Excel: find duplicates
Excel compare tables - method 2
- You will have to copy the first table and paste it on a new sheet in the same file.
- Now select the pasted table, if this is not selected.
- In the "Start" menu, click on "Conditional formatting" and determine a "New rule".
- Select "use a formula to determine the formatting of cells from" and enter the formula "=A1Tab1!A1" a. Here, we assume that the table starts in the field A1. Of course, you can leave the formula in another field to start.
- Then all Changes are marked and you can compare the tables directly.
Excel spreadsheet compare
How to use the Excel table, then in Word, insert can, we show you in the next article.
