Microsoft Office Tutorials and References
In Depth Information
Pasting range names into formulas
Excel color-codes the range addresses and ranges when you’re entering or editing a formula. This helps you quickly
spot the cells that are used in a formula.
When creating a formula by pointing, you can also point to the data cells by using your mouse.
Pasting range names into formulas
If your formula uses named cells or ranges, you can either type the name in place of the
address, or choose the name from a list and have Excel insert the name for you
automatically. Two ways to insert a name into a formula are available:
Select the name from the drop-down list. To use this method, you must know at
least the fi rst character of the name. When you’re entering the formula, type the
fi rst character and then select the name from the drop-down list.
Press F3. The Paste Name dialog box appears. Select the name from the list and
then click OK (or just double-click the name). Excel enters the name into your
formula. If no names are defi ned, pressing F3 has no effect.
Figure 15.3 shows an example. The worksheet contains two defi ned names: Expenses and
Sales . The Paste Name dialog box is being used to insert a name ( Sales ) into the formula
being entered in cell B9.
FIGURE 15.3
Use the Paste Name dialog box to quickly enter a defi ned name into a formula.
15
Search JabSto ::




Custom Search