It is often convenient to name a range of cells. When a range is identified, you can jump to a range name and use range names in a formula, making them easier to read.
A named variable or range, when used in a formula, is an absolute reference, i.e. you don't need to use the awkward $ symbols.
By defining a range name you assign a name to a specific cell or group of cells. If you have a lot of cells to name, refer to Creating Range Names below.
A name cannot contain spaces. If you wish to use multiple words, either separate them with an underscore or capitalize the first letter of each word, i.e. Exp_description, or ExpDescription. It is also good advice to keep descriptions short.
If you select a name from the list of named ranges, Excel jumps to the range and selects all cells within the range.
To select a named range:
To see a list of all the named ranges in your workbook follow the instructions indicated in Step 1 under Go To A Named Range or press the F3 key. For more options:
If you create range names Excel will recognize data associated beside, under, or above row and column headings, and create the names automatically. Using the example below, if you wanted to name cell B1 with the text in cell A1 and cell B2 with the text in A2, etc. you could use this trick to quickly create these names.
If a name is defined for a single cell , i.e. JanTotal, you can paste the contents of the cell anywhere in the workbook by typing =Name i.e. =JanTotal.
If you have named cells and/or ranges in your workbook, you can include their names rather than their cell addresses when creating formulas. When you want to insert the name reference, you can select the name from a list by pressing the F3 key.
An added bonus to using named cells and/or ranges is that their references do not change when copied; hence, an absolute reference is not required if the cell being referenced is referred to by its name.
In the following example we will assume that cells B4 to B8 are named January. Cells C4 to C8 are named February.
=SUM(JANUARY) rather than =SUM(B4:B8) much easier to read, huh?
=AVERAGE(JANUARY) rather than =AVERAGE(B4:B8)
=SUM(JANUARY)*1.04 rather than =SUM(B4:B8)*1.04
Better yet.if 1.04 was placed in another cell and named INCREASE, you could enter the formula =SUM(JANUARY)*INCREASE
When creating a formula, rather than typing a name or cell reference, simply click in the cell, or drag over the range, and Excel will insert the name or cell reference for you. This trick reduces errors in incorrect cell references.