Edit Cell (Excel Shortcut)

Last Updated: January 10, 2024
puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

In Excel, editing a cell is a very commonly used task. If the user needs to edit any value or formula entered in the cell.

He/She can edit the cell at any point using the manual option by double clicking on the cell or by using the keyboard shortcut and when you make the active cell to edit mode, you will notice the straight blinking line within the cell.

cell-in-edit-mode

Keyboard Shortcut to Edit Cell in the Excel

Fn (Function key) + F2

Steps to Edit Cell Using Keyboard Shortcut

  1. First, go to the cell which you want to edit.
  2. After that, simply press the “Fn + F2” keys and your active cell will change into edit mode and you will see the straight blinking line within the cell at the end of your value or formula into the cell.
  3. Now, with the help of the left and right navigation keyboard keys, you can move the blinking line in the left and right directions to edit the required character in the cell.
  4. Once you are done with editing, just press enter to make the cell active again.

Points to Remember

  • Users can edit one cell at a time.
  • By default, Editing happens in the cell, but the user can change the default settings by unchecking the “Allow editing directly in cells” under the Advanced option to make the editing happen in the “Formula” Bar.
excel-options-dialog-box