Example: Using F2 Key to Edit a Cell’s Contents
This example covers how to edit a formula in Excel
Enter 4 into cell D1, 5 into cell D2, and 6 into cell D3. Select cell E1 to make it the active cell. Enter the following formula into cell E1 = D1 + D2 Press the Enter key on the keyboard to complete the formula. The answer 9 should appear in cell E1. Select cell E1 to again make it the active cell. Press the F2 key on the keyboard. Excel enters edit mode and the insertion point is placed at the end of the current formula. This is the same as double-clicking the cell with the mouse. Modify the formula by adding + D3 to the end of it. Press the Enter key on the keyboard to complete the formula and leave edit mode. The new total for the formula (15) should appear in cell E1.
You can tell when Excel is in Edit mode by looking in the lower-left corner of the window. The word Edit will appear in the Status bar when Edit mode is activated.
= D1 + D2
Edit mode enables you to move the text cursor within the formula using the right and left arrow keys.
If you press F2 again, the formula goes into Enter mode. In Enter mode, you can use the arrow keys to select cells instead of moving the text cursor.
