Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
The larger and more complex your
spreadsheets become, the harder it is to
remember where the most important data is in the file.
If you find yourself searching for the same data
again and again, consider assigning a range name
to the cells containing that data. By assigning a
descriptive name to a single cell or range of cells,
you will be able to find that data more quickly.
Shorter Names Are Better
Although range names can be up to 255
characters long, shorter names are better as
long as they are still descriptive enough to
Naming a Range of Cells
Even though range names are meant to be
customized to your requirements, you will still need
to follow these simple rules.
To name a cell or cell range, follow these steps:
1. Select the cell or cell range you want to name.
2. Click the Name box and type the new name
for the selected range of cells (see Figure 1-24).
Range names cannot contain spaces.
Use an underscore to take the place of
a space. For example, instead of Spring
Sales, the range name would be
3. Press Enter to accept the change and continue
Range names must begin with a letter,
not a number. For example, use
Quarter_3, not 3rd_Quarter.
Range names cannot be named anything
that might be interpreted by Excel to
mean an actual cell address. For example,
Q3 is not a good range name because it
could be a valid cell address, whereas
Quarter3 would make an acceptable
Creating a range name in the Name box.