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.
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.