Constants are cells whose contents are deemed not to be a formula, so those cells whose values do not begin with an equal sign are constants, whether they are numbers or text.
The Formula option selects cells that meet the selection criteria of values returned as numbers, text, logical, or errors.
As you learned at the beginning of this hour, you can use the Go To Special command to find constants.
To do so, just press F5 (Go To) and click the Special button in the Go To dialog box. The Go To Special dialog box appears, as shown in Figure 16.10.
In the Go To Special dialog box, select Constants (see Figure 16.10). Excel automatically ...