Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Naming Cells and Ranges
Naming Cells and Ranges
When you use names in Excel to address or represent a cell, a range of cells,
or constants, you can make your functions and formulas much more meaningful
and so much easier to handle. It is much easier to use Average(Sales) than Average
(B738:B897). Another example is when using names in a meaningful way in a for-
mula: Use Cost_January
A3. I prefer to use names in
Excel when I calculate statistics on a large range of numbers.
Excel allows you to define a name or names in a variety of ways. Once you adopt
the practice of using names in your workbooks, you can easily update, audit, and
manage these names. I will show you that naming cells or a range of cells can save
you precious time and effort when you use them for calculations, statistics, and
decision-making applications. I will also demonstrate that names are helpful when
presenting your calculations to an audience; or when you copy your formulas to
other applications such as Word and PowerPoint.
All the cells in Excel are automatically given a specific name that places them in a
specific column and row position
Cost_February instead of A2
the address. In many situations, you may want to
rename a cell or a range of cells to make it easier to refer to the data, which those cells
or ranges contain. The following demonstrates the concept with a simple example.
NAMING A SINGLE CELL
In the example in the Chapter 4 workbook, in the sheet called Names Concept I
would like to use a tax rate of 15 percent. Instead of using absolute addressing,
I would like to name the cell corresponding to that 15 percent tax and call it
The value 15 percent was entered in cell G1. See Figure 4.1.
To name cell G1
select the Name box, above column A and to the left of
the Formula bar. Type the word Tax and click Enter. This will name cell G1 Tax, in
addition to its original name/address G1. See Figure 4.2.
From now on, you may use this new name anywhere in this workbook. For
example, if you type a formula in any cell:
200*Tax, it will result in the value 30.
Using the Name box is only one way to name or rename cells or ranges. There are a
number of other ways.
To illustrate again how to use the name in the above example, try calculating the
tax for all the entries in column F. Type
in cell F3, click on E3, type *, and click on
cell G1. It will show up as
E3*Tax, as you can see in Figure 4.3.