Table of Contents### Entering and Editing Formulas

Entire Site

Entering a new formula into a worksheet appears to be a straightforward process:

1. | Select the cell in which you want to enter the formula. |

2. | Type an equals sign (=) to tell Excel that you're entering a formula. |

3. | Type the formula's operands and operators. |

4. | Press Enter to confirm the formula. |

However, Excel has three different input modes that determine how Excel interprets certain keystrokes and mouse actions:

When you type the equals sign to begin the formula, Excel goes into Enter mode, which is the mode you use to enter text (such as the formula's operands and operators).

If you press any keyboard navigation key (such as Page Up, Page Down, or any arrow key), or if you click any other cell in the worksheet, Excel enters Point mode. This is the mode you use to select a cell or range as a formula operand. When you're in Point mode, you can use any of the range-selection techniques that you learned in Chapter 1, “Getting the Most Out of Ranges.” Note that Excel returns to Enter mode as soon as you type an operator or any character.

If you press F2, Excel enters Edit mode, which is the mode you use to make changes to the formula. For example, when you're in Edit mode, you can use the left and right arrow keys to move the cursor to another part of the formula for deleting or inserting characters. You can also enter Edit mode by clicking anywhere within the formula. Press F2 to return to Enter mode.

TIP

You can tell which mode Excel is currently in by looking at the status bar. On the left side, you'll see one of the following: `Enter`, `Point`, or `Edit`.

After you've entered a formula, you might need to return to it to make changes. Excel gives you three ways to enter Edit mode and make changes to a formula in the selected cell:

Press F2.

Double-click the cell.

Use the formula bar to click anywhere inside the formula text.

Excel divides formulas into four groups: arithmetic, comparison, text, and reference. Each group has its own set of operators, and you use each group in different ways. In the next few sections, I'll show you how to use each type of formula.