Working with Special Features |
With Excel’s Go To command, you can select all the cells on your worksheet that contain formulas, numbers, or text. Here’s how:
Select Go To from the Edit menu.
In the Go To dialog box, click the Special button.
Tell Excel what to select, as follows:
To select every formula cell, select Formulas.
To select every cell containing text (but not formulas), select Constants, then deselect the Numbers, Logicals, and Errors check boxes.
To select every cell containing numbers (but not formulas), select Constants, then deselect the Text, Logicals, and Errors check boxes.
Click OK.
(Posted 07/21/2000)