Microsoft Office Tutorials and References

In Depth Information

**Naming a Range of Cells**

FIGURE 4.4
Using the Name Tax

not case-sensitive

—

so you can type tax) in the formula and it will result in the

15 percent

even if the Tax cell was on a different sheet in the Excel workbook.

The above example illustrates the simplest way of creating a name for a single

cell. I will show a number of other examples and techniques to name a range of cells

and to use more efficient ways to create names.

—

NAMING A RANGE OF CELLS

If you have, for example, a set of 20,000 numbers in a range and you want to obtain

different calculations for the range, you may not want to select the range or type the

range address in the function more than once. In the second example, on the sheet

called Statistics, I entered the values in the range B1:E5000. I would like to calculate

for the range the average, sum, standard deviation, and the median.

I clicked on a single cell in the range and selected the range by using the shortcut

CTRL

*. I clicked on the Name box, typed the word Data, and clicked

Enter. I changed the name of the range so range B1:E5000 is now called Data. See

Figure 4.5.

þ

Shift

þ

FIGURE 4.5
The Range B1:E5000 Now Has the Name

“

Data

”