Using Named Constants and Formulas
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.
Using Constants
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.
Figure 16.10. Selecting constants in the Go To Special dialog box.
In the Go To Special dialog box, select Constants (see Figure 16.10). Excel automatically ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
