1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Using a Range Name in Excel Formulas


Basic Excel 2010 Ecourse Tutorial Step 5
Adding a Range Name in Excel

Adding a Range Name in Excel

© Ted French

Related Tutorial: Excel Range Name Overview

A range name is an easy way to avoid the problem of changing cell references when copying formulas to additional cells in the worksheet.

When a range name is assigned to a cell then the range name is used in the formulas rather than the cell reference.

Even when copied to other cells, the range name will always refer to the original cell.

Tutorial Steps:

For help on these steps, refer to the image above.

  1. If necessary, open the worksheet saved in the previous step of the tutorial.

  2. Click on cell C5 in the worksheet.

  3. Click on the Name Box located above column A.

  4. Type "rate" (no quotes) in the Name Box.

  5. Press the ENTER key on the keyboard.

  6. Cell C5 now has the range name of "rate". We will use the name to simplify creating the Deduction formula in the next step of the tutorial.

  7. Save your worksheet.

©2014 About.com. All rights reserved.