Description: Go To Special is not only used for moving to a particular cell, it can be used in multiple ways.
Row Difference
Feature used for finding the difference between column values. This will select all cells, which have a different from the first column
Select Row Difference option from the Go to special screen, it will high light the mismatched cells.
Other usages: Go to special can be used for removing Constants from an excel sheet or for removing the blank rows/cells, remove the formulas, etc.
Thursday, August 27, 2009
Subscribe to:
Posts (Atom)