به روز

Range notation you’re intuitive. To know what

a formula such as =SUM(E6:E10) is adding, you

have to look at the range itself.

􀀃 􀁑􀀃 A slight mistake in defining the range coordinates

can lead to disastrous results, especially

when you’re erasing a range.

You can overcome these problems by using range

names , which are labels applied to a single cell or to

a range of cells. With a name defined, you can use

it in place of the range coordinates. For example, to

include the range in a formula or range command,

you use the name instead of selecting the range or

typing in its coordinates. You can create as many

range names as you like, and you can even assign

multiple names to the same range.

Range names also make your formulas intuitive

and easy to read. For example, assigning the name

AugustSales to a range such as E6:E10 immediately

clarifies the purpose of a formula such as

=SUM(AugustSales) . Range names also increase the

accuracy of your range operations because you don’t

have to specify range coordinates.

Besides overcoming these problems, range names

bring several advantages to the table:

Names are easier to remember than range

coordinates.

 Names don’t change when you move a range to

another part of the worksheet.

 Named ranges adjust automatically whenever you insert or delete rows or columns

within the range.

 Names make it easier to navigate a worksheet. You can use the Go To command to

jump to a named range quickly.

You can use worksheet labels to create range names quickly.

This chapter shows you how to define and work with range names, but it also shows you

the power and flexibility that range names bring to your worksheet chores.