Thursday, July 11, 2013

Some Excel Key Board Shortcuts

Posted by Sharath Chandra
It looks like simple topic - but I bet many of you don't know these shortcuts (in my experience I came to know this). Here goes the useful Excel Shortcuts

  • To hide current row, press ctrl+9
  • To hide current column, press ctrl+0
  • To unhide rows in selected range, press ctrl+shift+9
  • To unhide columns in selected range, press ctrl+shift+0
  • To edit active cell, press F2 (places cursor in the end)
  • To enter multiple lines in a cell, press alt+enter
  • To repeat last action, press F4
  • To edit a cell comment, press shift + F2
  • To insert current date, press ctrl+;
  • To insert current time, press ctrl+shift+;
  • To apply outline border around selected cells, press ctrl+shift+7
  • To autosum selected cells, press alt + =
  • To copy value from above cell, press ctrl+’
  • To see the suggest drop-down in a cell, press alt + down arrow
  • To format current cell with comma formats, press ctrl+shift+1
  • To go to the next worksheet, press ctrl+shift+pg down
  • To go to the previous worksheet, press ctrl+shift+pg up
  • To insert a new sheet, press shift + F11
  • To format any selected object, press ctrl+1
  • To recalculate formulas, press F9
  • To select data in current region, press ctrl+shift+8
  • To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
  • While editing formulas to change the reference type from absolute to relative vice versa, press F4
  • To format a number as currency, press ctrl+shift+4 (ctrl+$)
  • To open the macros dialog box, press alt+F8

[*Courtesy: Where you become Excellent]