» Selecting Special Cells

CATEGORY - Excel Keyboard Shortcuts VERSION - All Microsoft Excel Versions

Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more (see the Go To Special dialog box) enables you to copy, move, delete, color, fill, or protect these cells.

To select special cells:

1. Press F5, or from the Edit menu, select Go To.
2. In the Go To dialog box, click Special.
3. Select one of the option buttons, and click OK.
Screenshot // Selecting Special Cells