Sunday, December 4, 2011

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.

    http://www.computerfreetips.com/Office_Tips/scrolling_office.html 

No comments:

Post a Comment