01

of 01

### Excel Edit Cells Shortcut Key

### Excel Edit Cells Shortcut Key

The function key ** F2** allows you to quickly and easily edit the data of a cell by activating Excel's edit mode and placing the *insertion point* at the at the end of the active cell's existing contents. Here is how you can use the F2 key to edit cells.

### Example: Using F2 Key to Edit a Cell's Contents

This example covers how to edit a formula in Excel

- Enter the following data into cells 1 to D3: 4, 5, 6
- Click on 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 - Click on 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 - 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

**Note:** If the option to allow editing directly in cells is turned off, pressing the F2 key will still put Excel in edit mode, but the insertion point will be moved to the formula bar above the worksheet in order to edit the cell's contents.