Microsoft Office Tutorials and References
In Depth Information
Clarifying Cell References by Naming a Range
Here you can type the range name, and even add a descriptive comment about the
range if you like. The Refers to: field lets you type the range coordinates (e.g., C23:C42)
without having to actually select those cells first, unlike the first technique.
prefix identifies the sheet in which the range was drawn.
Scope refers to the worksheets in the workbook in which you can use the range. By
default, the scope of a range is defined as Workbook, and that means that you can use
the range name in any of the worksheets that make up the book—so even if you’ve
on Sheet1, you’ll be able to write the following in Sheet2 as well:
But if you confine the scope of
Sheet1, you’ll only be able to use
formulas in Sheet1 (see Figure 4–34).
Figure 4–34. You can’t get there from here: don’t try
using Score in Sheet2 now.
But why would you want to bother imposing such a restriction? Because you might be
working with different sets of test scores on different worksheets, and you might want to
use the range name
on each sheet—to represent only that sheet’s scores. True,
that’s not a likely scenario, but Excel makes the option available.