Using Names


User-defined names are an easy way to identify a cell, a range of cells, a value, or a formula. For example, the formula =Sales-Expenses is much clearer than =A10-A6. When you create a name for a range of cells, you can use that name (without quotation marks) in formulas.

You can also use names to identify constants and formula expressions. For example, you might define the name LtSp as 186000. You could then use the name LtSp in all your formulas.

To define names:

  1. If you are naming a range, select it.
  2. Select Insert > Name. The Defined Name dialog, shown below, will appear.

  3. When you are finished, click OK.

Do not use the names Print_Area or Print_Titles. Formula One for Java reserves those names for its own use.