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

Lesson 13. Working with Ranges > Inserting a Range Name into a Formula or Funct...

Inserting a Range Name into a Formula or Function

As previously discussed in this lesson, range names make it easy for you to specify a range of cells in a formula or function. To insert a range name into a formula or function, follow these steps:

  1. Click in the cell where you want to place the formula or function.

  2. Type the formula or function (begin the formula or function with the equal sign).

  3. When you are ready to insert the range name into the formula or function, select the Insert menu, point at Name, and select Paste. The Paste Name dialog box appears (see Figure 13.4).

    Figure 13.4. Use the Paste Name dialog box to insert a range name into a formula or function.

  4. Select the range name you want to place in the formula or function, and then click OK.

  5. Finish typing the formula or function (including the appropriate operators).

  6. Press Enter to place the formula or function into the cell and return the calculated value.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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