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.
0 komentar:
Post a Comment