Edit Cells with the F2 Function Key in Excel

01
of 02

Excel Edit Cells Shortcut Key

Excel Shortcut Keys - Edit Cell Contents
Edit Cell Contents in Excel. © Ted French

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.

02
of 02

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

 This example covers how to edit a formula in Excel

  1. Enter the following data into cells 1 to D3: 4, 5, 6
  2. Click on cell E1 to make it the active cell
  3. Enter the following formula into cell E1:
    = D1 + D2
  4. Press the Enter key on the keyboard to complete the formula - the answer should appear in cell E1
  5. Click on cell E1 to again make it the active cell
  6. Press the F2 key on the keyboard
  7. Excel enters edit mode and the insertion point is placed at the end of the current formula
  8. Modify the formula by adding + D3 to the end of it
  9. 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.