How to quickly compare data in Excel

Prepare a column of data and check the data in these two columns.

You only need to select the values ​​in these two columns. The slash is the slash above the carriage return. Then different data in the two columns will be selected, and then we can add colors to these cells to distinguish them.

Next is the horizontal table. Select two rows and press CTLR SHIFT. Then color-code the data so that you can quickly check it.

The above is the detailed content of How to quickly compare data in Excel. For more information, please follow other related articles on the PHP Chinese website!