Editing the content of a cell in Excel file.
Excel provides many ways to modify the contents of worksheet cells. The word Edit refers to the action of modifying contents of cells in a worksheet. After modifying the content of a cell, the Enter or Tab key is pressed.
Excel provides three techniques to edit the content of a cell.
By pressing F2 function key.
By clicking in the Formula bar.
By double-clicking inside a cell.
While editing the contents of a cell the Status bar displays "Edit", which shows Edit mode. In Edit mode, you can use different keys to navigate within the boundary of the cell.
Press Right or Left arrow key to move one character at a time.
Press Home key to move to the beginning of the entry.
Press End to move to the end of the entry.
Press Ctrl + Right or Left arrow to move to the next or previous word.
Press Del or Backspace to delete one character right or left to the insertion point.
Press Ctrl + Del to delete everything from the insertion point to the end of entry.
Press F2 again to exit Edit mode.