Editing A Formula

You can edit your formulas just as you could any other cell. Here are three common ways:

1. Double-click in the cell, which allows direct editing right in the cell.

2. Click in the cell, then press your F2 key on your keyboard.

Note: These two cell-editing techniques can only happen if you have the Edit Directly In Cell option turned on. If not working when you attempt to do either of these, then go to Tools->Options and click on the Edit tab and click on the Edit Directly In Cell option.

3. Click in the cell to select the formula you want edited. Then click in the Formula bar. This lets you edit the formula directly in the Formula bar.