Microsoft Office Tutorials and References
In Depth Information
Clarifying Cell References by Naming a Range
5.
Click Paste Values (the first button in the Paste Values group). The bonus
test scores will appear in cells P8:P12 in addition to their original
location—and they will appear as values , as if you had simply typed
them There are no formulas in the destination range, and that means
simply that the values in those cells won’t be changed by data entry
anywhere else in the workbook. They’ve been fixed.
NOTE: Notice the two other Paste Values buttons in Figure 4–29. The middle button, Values
and Number Formatting, will paste cell values plus any special formatting brought to those
values (e.g., currency formatting). The right button, Values and Source Formatting, pastes the
cell values along with any new formatting imparted to those cells (e.g., a different font or
color). Again, we’ll discuss formatting in Chapter 5.
Clarifying Cell References by Naming a Range
I’ve already introduced the pivotal concept of ranges, and you’ve already worked with
quite a few of them besides. But there are a few additional aspects of ranges that are
useful to know about.
For one thing, ranges can be named. That is, instead of working with a set of cell
references such as C23:C42 and using that reference in a formula, you can substitute a
name for it and use the name in the formula. For example, if this range contained test
scores, you could name the range
Scores
—and instead of writing
=MAX(C23:C42)
you could write
=MAX(Scores)
Naming a range helps you and other people who view your worksheet to better
understand exactly what sort of data has contributed to the range.
Scores
is a lot more
revealing than C23:C42—and probably easier to write, too. And there are other
advantages to naming a range, which we’ll discuss here too.
Naming a range is easy, although as usual, Excel grants us several ways in which to
carry out this task.
Naming a Range in the Name Box
The simplest technique is to name a range with the Name box:
1.
Select the range you want to name.
2.
Then click in the Name box—that field in the upper left of your
worksheet—type your name, and press Enter. (see Figure 4–30)
 
Search JabSto ::




Custom Search