» Selecting Special Cells in Excel 2007
Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more, enables you to copy, move, delete, color, fill, or protect these cells.
To select special cells:
1. Press .
2. In the Go To dialog box, click Special.
3. Select one of the option buttons, and click OK.
Select Home -> Find & Select-> click one of the options appearing in the menu list or click Go To Special.
|Screenshot // Selecting Special Cells in Excel 2007|