Microsoft Office Tutorials and References

In Depth Information

**Using Cell References in Formulas**

Here are some of the ways to get into cell edit mode:

Double-click the cell, which enables you to edit the cell contents directly in

the cell.

■

Press F2, which enables you to edit the cell contents directly in the cell.

■

Select the cell that you want to edit, and then click in the Formula bar.
This

enables you to edit the cell contents in the Formula bar.

■

If the cell contains a formula that returns an error, Excel will display a small

triangle in the upper-left corner of the cell.
Click the cell, and you’fill see an error

button appear. Click the button, and you can choose one of the options for

correcting the error. (The options will vary according to the type of error in the cell.)

■

You can control whether Excel displays these formula error buttons in the Formulas tab of the Excel Options dialog

box. To i nd this setting, choose File ➪ Options ➪ Formulas. If you remove the check mark from Enable background

error checking under Error Checking, Excel no longer displays these buttons.

While you’re editing a formula, you can select multiple characters either by dragging over

them or by pressing Shift while you use the navigation keys.

If you have a formula that you can’t seem to edit correctly, you can convert the formula to text and tackle it again

later. To convert a formula to text, just remove the initial equal sign (
=
). When you’re ready to try again, type the

initial equal sign to convert the cell contents back to a formula.

Using Cell References in Formulas

Most formulas you create include references to cells or ranges. These references enable your

formulas to work dynamically with the data contained in those cells or ranges. For example,

if your formula refers to cell A1 and you change the value contained in A1, the formula

result changes to reﬂ ect the new value. If you didn’t use references in your formulas, you

would need to edit the formulas themselves in order to change the values used in the

formulas.

15

Using relative, absolute, and mixed references

When you use a cell (or range) reference in a formula, you can use three types of references: