Home > Sample chapters > Microsoft Office > Excel

Using Formulas and Functions in Microsoft Excel 2013

Assigning names to groups of cells

When you work with large amounts of data, it’s easy to lose track of which cells contain which data. In addition, it can be difficult to locate data in workbooks that you didn’t create. Although you might always store product prices in one worksheet column, there’s no guarantee that your colleagues will follow the same pattern! One way to prevent confusion is to define a named range for any cell group that holds specific information. For example, in a worksheet with customer order data, you can define the Totals named range to represent the cells in which the total for each order is stored. After you define the named range, you can display its contents, rename it, or delete it.

Create a named range

  1. Select the cells that you want to name.

  2. Click the Name Box on the formula bar.

  3. Type the name that you want for the range.

    httpatomoreillycomsourcemspimages1602909.jpg
  4. Press Enter.

Go to a named range

  1. Click the Name Box down arrow.

  2. Click the range to which you want to go.

    httpatomoreillycomsourcemspimages1602911.jpg

Delete a named range

  1. Click the Formulas tab.

  2. Click Name Manager.

  3. Click the named range that you want to delete.

  4. Click Delete.

  5. Click OK to clear the confirmation dialog box that appears.

  6. Click Close.

Rename a named range

  1. Click the Formulas tab.

  2. Click Name Manager.

  3. Click the named range that you want to rename.

  4. Click Edit.

  5. Type a new name for the range.

  6. Click OK.

  7. Close the Name Manager dialog box.

    httpatomoreillycomsourcemspimages1602915.jpg
    httpatomoreillycomsourcemspimages1602917.jpg