Microsoft Office Tutorials and References
In Depth Information
CELLS AND RANGES
In Excel, you can name individual cells and groups of
cells, called ranges. A cell named Tax or a range
named Northern_Region is easier to remember than
the corresponding cell address. You can use named
cells and ranges directly in formulas to refer to the
values contained in them. When you move a named
range to a new location, Excel automatically updates
any formulas that refer to the named range.
When you name a range, you determine the scope of
the name by telling Excel whether it applies to the
current worksheet or the entire workbook. You can
name several ranges at once by using Excel’s Create
from Selection option. You can use the Name
Manager to delete named ranges.
Excel range names must be fewer than 255 characters.
The first character must be a letter. You cannot use
spaces or symbols except for the period and
underscore. It is best to create short, memorable
names. To learn how to use a named range, see
N AME A R ANGE OF C ELLS
Click and drag to select the cells
you want to name.
Alternatively, click in a cell with a
value to create a named cell.
Click the Formulas tab.
Click Define Name.
l The New Name dialog box
4 Type a name for the range.
5 Click here and then select the
scope of the range.
l The range you selected in Step 1
6 Click OK.
Excel creates a named range.
l The defined name is now
available when you click Use in