O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required