Using Row differences, you compare the data in a cell that belongs to a row with other cells in the same row and highlight the cells that have different data. Also, you can extend the selection area. You can select multiple rows of data and Excel will do the comparison for you automatically. An example will make you understand this feature clearly. The following figure shows the sample temperature reading for a period of 5 years with data recorded month wise.
In the figure to the right, the data in cell C4 which is 23 is compared with other cells in that row, which are 23, 23, 24, and 23. You will see the data that is different is present in cell F4. Similarly when you compare the data in C5 which is 31 with other cells in that row, you will see that the data in the cells E5 (32) and G5 (30) are different. When we do the comparison for the rest of the data, we expect Excel to highlight the cells that have different data.Perform the following to use the Row differences feature:
1. Highlight cells C4 to G15.
2. On the Home tab, in the Editing group, click Find & Select and click Go To Special...
3. In the Go To Special dialog box, click Row differences and click OK.
4. On the Home tab, in the Font group, click the Fill Color command and pick a color.
Additional Reading:
The figure above highlighted all the cells that has data that is different from the data that is present in column C. In practical terms, you have compared the temperature of each month in 2006 with the months in other years.
To do the comparison for the year 2007 with other years. You may first try the following:
1. Highlight all the cells. On the Home tab, in the Font group, click the Fill Color command and click No Fill.
2. With the cells still highlighted. Press the TAB key. The active cell is moved to the cell D4.
3. On the Home tab, in the Editing group, click Find & Select and click Go To Special...
4. In the Go To Special dialog box, click Row differences and click OK.
5. On the Home tab, in the Font group, click the Fill Color command and pick a color.
In the figure to the right, the data in cell C4 which is 23 is compared with other cells in that row, which are 23, 23, 24, and 23. You will see the data that is different is present in cell F4. Similarly when you compare the data in C5 which is 31 with other cells in that row, you will see that the data in the cells E5 (32) and G5 (30) are different. When we do the comparison for the rest of the data, we expect Excel to highlight the cells that have different data.1. Highlight cells C4 to G15.
2. On the Home tab, in the Editing group, click Find & Select and click Go To Special...
3. In the Go To Special dialog box, click Row differences and click OK.
4. On the Home tab, in the Font group, click the Fill Color command and pick a color.
Additional Reading:
The figure above highlighted all the cells that has data that is different from the data that is present in column C. In practical terms, you have compared the temperature of each month in 2006 with the months in other years.
To do the comparison for the year 2007 with other years. You may first try the following:
1. Highlight all the cells. On the Home tab, in the Font group, click the Fill Color command and click No Fill.
2. With the cells still highlighted. Press the TAB key. The active cell is moved to the cell D4.
3. On the Home tab, in the Editing group, click Find & Select and click Go To Special...
4. In the Go To Special dialog box, click Row differences and click OK.
5. On the Home tab, in the Font group, click the Fill Color command and pick a color.
0 comments:
Post a Comment