Microsoft Office Tutorials and References

In Depth Information

**Use a Range Name in a Formula**

Complete the formula by entering a close parentheses, or another function, and

then click the
Enter
button.

Use a Range Name in a Formula

Put your cursor where you would like the formula. Type an equal sign (=) fol-

lowed by the start of a formula, such as
=SUM(
.

Press F3 to display a list of named ranges.

• You can also click the
Use in Formula
button on the Formulas tab, and then

click
Paste
.

Click the name of the range you want to insert.

Click
OK
.