Microsoft Office Tutorials and References
In Depth Information
Naming a Range of Cells
FIGURE 4.4 Using the Name Tax
so you can type tax) in the formula and it will result in the
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
*. 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 The Range B1:E5000 Now Has the Name