Friday, January 20, 2012

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.
Share this post
  • Share to Facebook
  • Share to Twitter
  • Share to Google+
  • Share to Stumble Upon
  • Share to Evernote
  • Share to Blogger
  • Share to Email
  • Share to Yahoo Messenger
  • More...

0 comments:

Post a Comment