Tip Printed from ExcelTip.com

---

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.
Or
Select Home -> Find & Select-> click one of the options appearing in the menu list or click Go To Special.