Entering a range address in a formula
You can use a cell or range address in a formula to refer to data you want the formula to use. More power with formulas describes all the basic parts of a formula and the different types of formulas.
- Enter the formula up to the operator or ( (open parenthesis) that precedes the cell or range address you want to enter.
- Type the cell or range address.
For example, B4 refers to data in cell B4; A1..C7 refers to data in the range A1 to C7.
- When the formula is complete, press ENTER.
See also
More power with @functions
When and how formulas recalculate
Controlling how a formula refers to data
Fixing common errors in formulas
Editing a formula
Entering a range name in a formula
Copying a formula
Moving a formula