Thursday, August 27, 2009

Excel 2007 : Go To Special

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.