Learn Excel in telugu Naming a Cell or Range Part 16

Assign a descriptive name to a cell or range in Excel 2007 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of a formula, rather than using somewhat obscure cell references.

For example, the formula =SUM(Qtr2Sales) is much more intuitive than =SUM(C5:C12). In this example, you would assign the name Qtr2Sales to the range C5:C12 in the worksheet.
Naming cells

To name a cell or range, follow these steps:

Select the cell or cell range that you want to name.

You also can select noncontiguous cells (press Ctrl as you click each cell).

On the Formulas tab, click Define Name in the Defined Names group.

The New Name dialog box appears.
In the Name text box, type up to a 255-character name for the range.

Range names are not case-sensitive; however, range names must follow these conventions:

The first character must be a letter, an underscore, or a backslash.

No spaces are allowed in a range name.

Do not use a name that is the same as a cell address. For example, you can’t name a range U2 or UB40, but BLINK182 and ABBA are just fine.

Click OK.

Alternatively, you can enter a range name into the Name box located at the left end of the Formula bar and press Enter to create the name. You can jump quickly to a named range by clicking the down arrow in the Name box and selecting the range name.