Edit cells with F2 function key in Excel

Content
  1. Keyboard shortcut for editing Excel cells
  2. Keyboard shortcut for editing Excel cells
  3. Example: Using the F2 key to edit the contents of a cell

Keyboard shortcut for editing Excel cells

Keyboard shortcut for editing Excel cells

Function key F2 allows you to quickly and easily edit cell data by activating and placing Excel edit mode insertion point at the end of an existing active cell. content. This is how you can use the F2 key to edit cells.

Example: Using the F2 key to edit the contents of a cell

This example shows how to edit a formula in Excel.

  1. Enter the following data in cells 1 to D3: 4, 5, 6

  2. Click on cell E1 to make it active

  3. Enter the following formula in cell E1:

     = D1 + D2 
  4. Press key Enter on the keyboard to complete the formula – answer 9 would be in cell E1 . must appear

  5. Click on cell E1 to make it active again.

  6. Press key F2 on keyboard.

  7. Excel goes to edit mode and the insertion point is placed at the end of the current formula

  8. Change the formula by adding at the end + D3 .

  9. Press key Enter on the keyboard to complete the formula and exit edit mode – cell E1 should have a new total for the formula – 15 .

Remark. If the option to allow editing directly in cells is disabled, pressing F2 will still put Excel in edit mode, but the insertion point will be moved to the formula bar above the table in the following order. edit cell contents.

Leave a Reply

Your email address will not be published.