« Text Formulas: Extracting First & Last Names
Controls : PushButton »

Using names for cell ranges

You can define ranges as names from the Insert Menu. This makes subsequent enhancements and maintenance of the worksheet easy.

First, select the range of cells to which you wish to assign a name. Then INsert->Names->Define (below)

name_define.jpg

A dialog will appear as is shown below..

name_define2.jpg

You can then use the defined names to specify a range in a table as shown in this example.

expenses.jpg

If you change the Range name, the formulas will adjust automatically.

This entry was posted on Monday, September 20th, 2004 at 5:58 pm and is filed under Function Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Using names for cell ranges”

  1. Florian Says:
    December 3rd, 2007 at 11:39 am

    Thanks for the great site. You wouldn’t happen to know if I can somehow not use range names directly, but derive them from some other data?
    Let’s say I got 4 ranges, called “range1″, “range2″, “range3″ and “range4″.
    Now I’ve got a formula where I want to use one of these ranges, but which one is up to another data. So can I do something like =FORMULA(range+”data”) ?

  2. daniel Says:
    January 13th, 2008 at 3:53 pm

    Hi,

    first, thank for the hints!

    I created a cell range which changes depending if cells in a determined column are blank, using INDIRECT. I’d like to have this dynamic range in the chart as well, so as to not show blank labels and to allow people to create new labels that will be added dynamically to the chart. But I saw that the chart dialog doesn’t accept cell range’s names. Is there a way to do it?

    thanks!

    daniel tygel

Leave a Reply