Microsoft Office Tutorials and References
In Depth Information
CHAPTER 4: Working with 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. For
example, range names are more intuitive than range coordinates,
particularly in formulas; range names are more accurate than range
coordinates; range names are easier to remember than range
coordinates; and range names make it easier to navigate a worksheet.
This chapter explains range names and shows you how to define, edit,
and use range names.