Naming a range

You can name a range and use the range name in place of the range address. Range names are easy to remember and convenient to use in formulas and @functions. Named ranges are also easier remember when you want to find them in the worksheet. You can use the Go To command or press CTRL+G or F5 to find a named range in the worksheet.

  1. Select the range you want to name.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Name.

  4. Specify a range name.

  5. Click Define.

  6. (Optional) To name another range, repeat steps 1, 4, and 5.

  7. Click Done.



Details

When you save a worksheet, your spreadsheet saves the range names along with the sheet.

After you name a range, your spreadsheet substitutes the range name for the range address in any existing formulas that reference the range.

Conventions for naming ranges describes the rules to follow when naming ranges in your spreadsheet.



See Also
Going to a range in the worksheet
Entering a range name in a formula