Microsoft Office Tutorials and References
In Depth Information
Working with Excel Fundamentals
One more detail about ranges — you can give them a name. This is a great
feature because you can think about a range in terms of what it is used for,
instead of what its address is. Also, if we did not take the extra step to assign
a name, the range would be gone as soon as we clicked anywhere on the
worksheet. When a range is given a name, you can repeatedly use the range
by using its name.
Say you have a list of clients on a worksheet. What’s easier — thinking of
exactly which cells are occupied, or thinking that there is your list of clients?
Throughout this topic, I use areas made of cell addresses and ranges, which
have been given names. It’s time to get your feet wet creating a named area.
Here’s what you do:
1. Position the mouse pointer over a cell, click and hold the left mouse
button down, and drag the pointer around.
2. Release the mouse button when done.
You’ve select an area of the worksheet.
3. Click Define Name in the Defined Names category on the Formulas
The New Name dialog box appears. Figure 1-9 shows you how it looks
4. Name the area if need be.
Excel guesses that you want to name the area with the value it finds in
the top cell of the range. That may or may not be what you want. Change
the name if you need to. In this example, I changed the name to Clients.
An alternative method to naming an area is to select it, type the name in
the Name Box (left of the Formula Bar), and press the Enter key.
5. Click the OK button.
name to the