Microsoft Office Tutorials and References
In Depth Information
pears, as shown in Figure 3-13. In the Apply Names dialog box, select which names you want applied to the
formulas. Only those names that you select will be applied to the formulas.
Figure 3-13: The Apply Names dialog box.
To apply names to all the formulas in the worksheet, select a single cell before you dis-
play the Apply Names dialog box.
The Ignore Relative/Absolute check box controls how Excel substitutes the range name for the actual address.
A cell or range name is usually defined as an absolute reference. If the Ignore Relative/Absolute check box is
selected, Excel applies the name only if the reference in the formula matches exactly. In most cases, you will
want to ignore the type of cell reference when applying names.
If the Use Row and Column Names check box is selected, Excel takes advantage of the intersection operator
when applying names. Excel uses the names of row and column ranges that refer to the cells if it cannot find the
exact names for the cells. Excel uses the intersection operator to join the names. Clicking the Options button
displays some additional options that are available only when you select the Use Row and Column Names
Applying names automatically when creating a formula
When you insert a cell or range reference into a formula by pointing, Excel automatically substitutes the cell or
range name if it has one.
In some cases, this feature can be very useful. In other cases, it can be annoying; you may prefer to use an actu-
al cell or range reference instead of the name. For example, if you plan to copy the formula, the range referen-
ces won't adjust if the reference is a name rather than an address. Unfortunately, you cannot turn off this feature.
If you prefer to use a regular cell or range address, you need to type the cell or range reference manually (don't
use the pointing technique).