MS-Excel Shortcut Keys

  1.  F2 – Edit the active cell
  2.  F5 – Go to a specific cell
  3.  F7 – Spelling & Grammar check
  4.  F11 – Create a chart
  5.  Ctrl+Shift+I – Enter the current Time
  6.  Ctrl+I – Enter the current date
  7.  Shift+F3 – Formula Window
  8.  Alt+Shift+F1 – Insert new sheet
  9.  Shift+F5 – Bring the search box
  10.  Ctrl+A – Select entire sheet
  11.  Ctrl+B – Bold  Ctrl+I – Italic
  12.  Ctrl+K – Insert hyperlink
  13.  Ctrl+U – Underline
  14.  Ctrl +5 – Strikethrough
  15.  Ctrl+P – Print
  16.  Ctrl+F9 – Minimize current window
  17.  Ctrl+F10 – Maximize current window
  18.  Ctrl+Page up/Ctrl+Page down – Move to next sheet and previous sheet
  19.  Ctrl+Tab – Move to next tab in a dialog box
  20.  Alt+= - Auto Sum
  21.  Ctrl+’ – Copy the above cell value
  22.  Ctrl+Shift+$ - Format the number in currency format
  23.  Ctrl+Shift+# - Format the number in date format
  24.  Ctrl+shift+% - Format the number in percentage format
  25.  Ctrl+Shift+A – Format he number in scientific format
  26.  Ctrl+Shift+@ - Format the number in time format
  27.  Ctrl+Space – Select entire Column
  28.  Shift+Space – Select entire row