Microsoft Office Tutorials and References

In Depth Information

**Chapter 2: Basic Facts about Formulas**

h
Press F2.
This enables you to edit the cell contents directly in the cell. If the Double-click

Allows Editing Directly in Cell check box is not selected, the editing will occur in the

Formula bar.

h
Select the formula 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.

When you edit a formula, you can select multiple characters by dragging the mouse over them or

by holding down Shift while you use the arrow keys. You can also press Home or End to select

from the cursor position to the beginning or end of the current line of the formula.

Suppose you have a lengthy formula that contains an error, and Excel won’t let you

enter it because of the error. In this case, 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 return to editing the formula, insert the initial equal sign to convert the

cell contents back to a formula.

Using the Formula bar as a calculator

If you simply need to perform a calculation, you can use the Formula bar as a calculator. For

example, enter the following formula into any cell:

=(145*1.05)/12

Because this formula always returns the same result, you may prefer to store the formula’s result

rather than the formula. To do so, press F2 to edit the cell. Then press F9, followed by Enter.

Excel stores the formula’s result (12.6875), rather than the formula. This technique also works if

the formula uses cell references.

This technique is most useful when you use worksheet functions. For example, to enter the

square root of 221 into a cell, type
=SQRT(221)
, press F9, and then press Enter. Excel enters the

result: 14.8660687473185. You also can use this technique to evaluate just part of a formula.

Consider this formula:

=(145*1.05)/A1

If you want to convert just the expression within the parentheses to a value, get into cell edit

mode and select the part that you want to evaluate. In this example, select 145*1.05. Then press

F9 followed by Enter. Excel converts the formula to the following:

=(152.25)/A1