News

How to find and highlight row differences in Microsoft Excel

If you have data in spreadsheets that you want to browse quickly, highlighting data differences automatically can save you time. Microsoft Excel has built-in features for easy display of row differences. Once you find different data, you can apply the formatting to highlight the differences, and then work on updating, correcting, or analyzing your spreadsheet data.

Find the difference of rows in Excel

The first step in determining the difference in data is to select the cells. To do this, drag the cursor over a group of cells or adjacent rows. Then from the top bar to the tab Home And section Editing go. Roy Find & Select Click and in the drop-down menu Go To Special Choose.

How to find and highlight row differences in Microsoft Excel

In the window that opens, Row Differences Select and tap OK click.

How to find and highlight row differences in Microsoft Excel

The window closes automatically and you can see the differences in the rows that are now highlighted.

How to find and highlight row differences in Microsoft Excel

Differences between cells and active rows

You should know that the highlighted differences are determined by the active cell. As you can see in the image below, the active cell is cell A1; Because its color is white. This cell is the first cell we selected when drawing the cursor to specify the range. The same rule applies if you select rows instead of cell range.

How to find and highlight row differences in Microsoft Excel

This means that the data in the next rows that are highlighted are different from the active cell column. In the image below you can see that cells B4 and C4 are highlighted; Because both are different from A4.

How to find and highlight row differences in Microsoft Excel

In the image below, only cell B5 is highlighted. This is because the data in C5 is consistent with A5.

How to find and highlight row differences in Microsoft Excel

If you want to change the active cell, you can use the Enter key in Windows or the keys TAB + Return Press on Mac to go to the cell you want to activate.

You can also start selecting a cell range with another cell to activate that cell. Keep in mind that differences in cell range or row selection affect the differences that are displayed to you.

An important point to keep in mind here is that the difference in rows is determined by the active cell.

How to find and highlight row differences in Microsoft Excel

Highlight row differences in Excel

After using the Go To Special feature above and highlighting the row differences you want, you can in the tab Home Stay away from the option formatting Use the formatting in the top bar of Excel.

Related article:

the part Font In the tab Home It gives you options to change the text to bold or italic or underline, as well as adjust the font style, size and color. In addition, you can select the background or border color for the cells.

How to find and highlight row differences in Microsoft Excel

One of the advantages of Microsoft Excel is that there are so many things that can be done in different ways. We hope this tutorial has been useful for you. If you have any questions or concerns about finding and highlighting row differences in Microsoft Excel, feel free to share them with us.


Source link

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker