Thursday, April 25, 2013

Excel Short Cuts Part-3

Edit Selected Cells    
  Ctrl + d Copy above cell.
  Ctrl + r Copy cell from the left.
  Ctrl + “ Copy above cell value and edit.
  Ctrl + ' (apostrophe) Copy above cell formulas and edit.
  Ctrl + l Insert a table (display Create Table dialog box).
  Ctrl + - Delete Cell/Row/Column Menu
  Ctrl + - with row or Column Selected Delete row / delete column.
  Ctrl + Shift + = Insert Cell/Row/Column Menu
  Ctrl + Shift + = with row or column selected Insert row/ insert column.
  Shift + F2 Insert / Edit a cell comment.
  Shift + f10, then m Delete comment.
  Alt + F1 Create and insert chart with data in current range as embedded chart object.
  F11 Create and insert chart with data in current range in a separate Chart sheet.
  Ctrl + k Insert a hyperlink.
   
Select inside cells  
  Shift + Arrow Left Select or unselect one character to the left.
  Shift + Arrow Right Select or unselect one character to the right.
  Ctrl + Shift + Arrow Left Select or unselect one word to the left.
  Ctrl + Shift + Arrow Right Select or unselect one word to the Right.
  Shift + Home Select from the insertion point to the beginning
  Shift + End Select from the insertion point to the End

No comments:

Post a Comment