Teach Yourself VISUALLY™ Microsoft® Office 2008 for Mac®

250

22

11

55

44

33

66

The Paste Name dialog appears.

5 In the Paste name list, click the

range name you want to use.

6 Click OK.

1 Click in the cell in which you want

to build the formula, type =, and

then type any operands and

operators you need before adding

the range name.

2 Click Insert.

3 Click Name.

4 Click Paste.

Add a Range Name to a Formula

You can make your formulas easier to build, more

accurate, and easier to read by using range names

as operands. For example, the formula

=SUM(B2:B10) is difficult to decipher on its

own, but the formula =SUM(Expenses) is

immediately obvious.

See Chapter 11 to learn how to define names for ranges in Excel.

Add a Range

Name to a Formula

15_485033-ch13.indd 25015_485033-ch13.indd 250 4/23/09 12:25:04 AM4/23/09 12:25:04 AM

251

Manipulating Formulas and Functions

chapter

13

Do I have to use the Paste

Names dialog to insert

range names into my

formulas?

No. As you build your

formula, you can type the

range name by hand, if you

know it. Alternatively, as you

build your formula, click the cell or

select the range that has the defined name, and

Excel adds the name to your formula instead of

the range address. If you want to work from a list

of the defined range names, click an empty area of

the worksheet, click Insert, click Name, click

Paste, and then click Paste List.

If I create a range name after

I build my formula, is there

an easy way to convert

the range reference to

the range name?

Yes. Excel offers an Apply

Names feature that replaces

range references with their associated

range names throughout a worksheet. Click Insert,

click Name, and then click Apply to open the Apply

Names dialog. In the Apply names list, click the

range name you want to use, and then click OK.

Excel replaces the associated range references with

the range name in each formula in the current

worksheet.

●

If you need to insert other range

names into your formula, repeat

Steps 2 to 6 for each name.

8 Press .

Excel calculates the formula result.

●

Excel inserts the range name into

the formula.

7 Type any operands and operators

you need to complete your

formula.

=SUM(B2:B10)

=SUM(B2:B10)

1

2

3

4

5

1

2

3

4

5

2

2

22

2

2

22

15_485033-ch13.indd 25115_485033-ch13.indd 251 4/23/09 12:25:04 AM4/23/09 12:25:04 AM