Selection of Row differences
This feature is mostly used, for to select the Row differences in the excel.
How to do this –
Step 2 - Choose the radio button Row differencesStep 3 - Then click on OK
How it works - First select the range of cells, then if we want to select the cells which are different from the active cell, this feature or trick will helps you a lot.
Step 1 - Please click on GoTo or press F5 under Home tab, then click on special will open a new dialogue box
Step 2 - Choose the radio button Row differencesStep 3 - Then click on OKHow it works - First select the range of cells, then if we want to select the cells which are different from the active cell, this feature or trick will helps you a lot.Remember - active cell is the cell which will be displayed on Name box at the time of selection, if you want to change the active cell use tab key on your key board to move around the range selected.
Comments
Post a Comment