For example, enter a cell as A1 instead of $A$1 or $A1 or A$.Ĭlick here to know more about relative references and “absolute references”. When we use the formulas, only relative references can be entered. Click OK, at this time the differences between the two worksheets values will be immediately highlighted. Set the format, select the highlight color for the mismatched data, and confirm.Ħ. This formula means that in the selected range of data, the data in Sheet2 will compare that of Sheet1 one by one and highlight the different cells.ĥ. “Sheet1!A2” indicates the reference to cell A2 in Sheet1; In this formula, “A2” indicates cell A2 of this worksheet; In the formula bar, enter = A2 Sheet1!A2. In the Select a rule type dialog box, click Use a Formula to determine which cells to format.Ĥ. Click the Home tab, select Conditional Formatting, and add New Rule.ģ. In the table, select the values that need to highlight the differences, here we select the data in sheet2.Ģ. The following are the specific steps of how to compare two excel sheets and highlight differences.ġ. Therefore, we need to integrate Book1 and Book2 into one workbook. Note: This method cannot compare two sheets in different workbooks. We can use Conditional Formatting to quickly highlight the different values in two Excel sheets. You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.įor example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row by row.īut if you are dealing with a large amount of data, this would not be a good way to do it. How to quickly compare two excel sheets for differences in values? In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |