Microsoft Office Tutorials and References
In Depth Information
Understanding the Benefits of Using Range Names
Understanding the Benefits
of Using Range Names
A range name is a text label that you apply to a
single cell or to a range of cells. Once you have
defined a name for a range, you can use that name
in place of the range coordinates, which has several
benefits. These benefits include making your
worksheets more intuitive and making your work
more accurate. In addition, a range name is easier to
remember than range coordinates, it does not change
when you move the underlying range, and it makes it
easier to navigate your worksheets.
More Intuitive
Range names are more intuitive than range
coordinates, particularly in formulas. For
example, if you see the range B2:B10 in a
formula, the only way to know what the range
refers to is to look at the data. However, if you
see the name Quarterly_Sales in the formula,
then you already know what the range refers to.
More Accurate
Range names are more accurate than range
coordinates. For example, consider the range
address A1:B3, which consists of four different
pieces of information: the column (A) and row
(1) of the cell in the upper-left corner of the
range, and the column (B) and row (3) of the
cell in the lower-right corner. If you get even
one of these values wrong, it can cause errors
throughout a spreadsheet. By contrast, with a
range name you need only reference the actual
name.
Search JabSto ::




Custom Search