• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Building Basic Formulas > Pasting a Name into a Formula

Pasting a Name into a Formula

One way to enter a range name in a formula is to type the name in the formula bar. But what if you can't remember the name? Or what if the name is long and you've got a deadline looming? For these kinds of situations, Excel has a feature that enables you to select the name you want from a list and paste it right into the formula. The following procedure gives you the details:

1.
In the formula bar, place the insertion point where you want the name to appear.

2.
Choose Insert, Name, Paste (or press F3). Excel displays the Paste Name dialog box, shown in Figure 3.6.

Figure 3.6. Use the Paste Name dialog box to paste a range name into a formula.


3.
Use the Paste Name list to highlight the range name you want to use.

4.
Click OK. Excel pastes the name in the formula bar.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint