Using Named Ranges in Formulas

Contact Us or call 1-877-932-8228
Using Named Ranges in Formulas

Using Named Ranges in Formulas

Some of the advantages to naming and labeling cells include:

  1. Using names can make it easier to understand what a formula does (e.g., =Q3Sales*Commission).
  2. Names work throughout a workbook, so using names can simplify the process of creating formulas that span multiple sheets.

Here is a list of things you need to know about cell names:

  1. The first character of a name must be either a letter, a backslash (\), or an underscore (_).
  2. Other (non-first) characters can be letters, numbers, underscores, or periods.
  3. Spaces cannot be used.
  4. The maximum number of characters in a name is 255.
  5. Any cell or range can be named, but (e.g., C10, $B$7) cannot be used as a name.
  6. Names are not case sensitive (e.g., the names "total", "Total", and "TOTAL" are the same in Excel).

Naming a Single Cell

To name a cell:

  1. Select the cell you wish to name.
  2. In the Name Box (to the left of the formula bar), type the name:
  3. Press Enter.

Naming a Range of Cells

To name a range of cells:

  1. Select the cells in the range you wish to name.
  2. In the Name Box (to the left of the formula bar), type the name:
  3. Press Enter.

Naming Multiple Single Cells Quickly

To quickly name cells using their row and column headings:

  1. Select the rows and columns containing the range you wish to name:
  2. On the FORMULAS tab, in the Defined Names group, click the Create from Selection command:
  3. In the Create Names from Selection dialog box, check the desired boxes and click OK:
  4. In the following image, cells can now be referred to using the row and column headings:
Next