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.