Microsoft Office Tutorials and References
In Depth Information
Naming A Range Containing One Cell: Why Bother?
Figure 4–37. Range names, batched up directly from the data—the titles in the left column and the top row
True to the Create Names from Selection dialog box, Excel has composed range names
from the data in the left column and top row, by assuming that those areas are likely to
contain header information that you could use as range names. That means that you can
now write a formula like this:
=AVERAGE(Walt)
NOTE: These ranges don’t include the cells in which the range names themselves appear.
Thus, the range called
Walt
spans J10:L10, not I10:J10. Note as well that even though the
subject heading Poli. Sci. consists of two words, Excel calls its range
Poli._Sci.
.
Naming A Range Containing One Cell: Why Bother?
Now here’s an important tip. You can assign a range name to exactly one cell—but why
would you want to? Because when you copy a formula with a range name, that range is
treated as an absolute reference—that is, the cells the range refers to don’t change
relative to their movement from the source cell that’s being copied.
Thus, if we look back at our bonus-grade example, we could have named the bonus cell
N7
Bonus
. Our original source formula in L8 (John’s score) would then have read
=K8+Bonus
And if we had then copied that expression down the column, all the other students’
bonuses would have been correctly figured right away—without the need for those
 
Search JabSto ::




Custom Search