Microsoft Office Tutorials and References
In Depth Information
Working with Range Names
Creating a Basic Worksheet
Select the cells you want to name.
Use the Name Box
2. Choose Formulas>Defined Names>Define
Name. The New Name dialog box appears.
Optionally, enter a range name into the Name
box located at the left end of the Formula bar.
3. In the Name text box, type a name for the
range (see Figure 8-21). Name the range
something that clearly identifies the area,
such as Income or Grades. Range names are
not case sensitive; however, range names
must follow these conventions:
Using Named Ranges
Jumping to a remote area in the worksheet is only
a mouse click away when you use range names,
because Excel provides a convenient drop-down
menu that you can use to move around quickly.
Click the down arrow in the Name box which
displays a list of named ranges such as you see in Figure
8-22. Select the range name you want to access and
Excel immediately highlights the named cells.
Creating a range name.
Range names must begin with a letter,
an underscore, or a backslash.
Quickly locate an area by choosing a range name.
Range names cannot include spaces.
Range names cannot include operator
symbols (+, -, *, /, <, >, or &).
Use the Go To Dialog Box
Range names can be up to 255
characters; however, shorter is better.
Optionally, display the Go To dialog box and
double-click on the range name you want to
Range names cannot be the same as a
cell address. For example, you can’t
name a range AB32.
4. Click OK.