Microsoft Office Tutorials and References
In Depth Information
The Range Name Game
You can also accomplish the same thing by selecting Home ➪ Find & Select ➪ Go
To or by pressing F5 or Ctrl+G to open the Go To dialog box (see Figure 6-9).
Double-click the desired range name in the Go To list box (alternatively, select
the name followed by OK). Excel moves the cell cursor directly to the named
cell. If you select a cell range, all the cells in that range are selected as well.
range to go
to in a
Name that formula!
Cell names are not only a great way to identify and find cells and cell ranges
in your spreadsheet, but they’re also a great way to make out the purpose of
your formulas. For example, suppose that you have a simple formula in cell
K3 that calculates the total due to you by multiplying the hours you work for
a client (in cell I3) by the client’s hourly rate (in cell J3). Normally, you would
enter this formula in cell K3 as
However, if you assign the name Hours to cell I3 and the name Rate to cell J3,
in cell K3 you could enter the formula
I don’t think there’s anyone who would dispute that the formula
=Hours*Rate is much easier to understand than =I3*J3.
To enter a formula using cell names rather than cell references, follow these
steps (see Chapter 2 to brush up on how to create formulas):
1. Assign range names to the individual cells as I describe earlier in this
For this example, give the name Hours to cell I3 and the name Rate to