MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Common Helpful Excel Keyboard Shortcuts


May 14, 2002 - by Juan Pablo Gonzalez

I thought about putting a small list of Keyboard shortcuts to make your life a little easier:

  • Ctrl + C: Copy
  • Ctrl + X: Cut
  • Ctrl + V: Paste
  • F2: Edit current cell (Makes cell references appear in colors for easy editing)
  • F5: Go to
  • F11: Instant chart.
  • Shift + F3: Paste function wizard
  • Ctrl + F3: Define Name
  • Ctrl + "+": Insert Cells, Rows, Columns. Depends on the current selection
  • Ctrl + "-": Delete Cells, Rows, Columns. Depends on the current selection
  • Shift + Space: Select entire row for current area (Hard to explain with words, try it out to see what it does)
  • Ctrl + Space: Select entire column for current area
  • Ctrl + ! (Or Ctrl + Shift + 1): Format as Number with 2 decimals
  • Ctrl + $ (Or Ctrl + Shift + 4): Format as Currency
  • Ctrl + % (Or Ctrl + Shift + 5): Format as Percentage
  • Ctrl + / (Or Ctrl + Shift + 7): Format as Scientific
  • Ctrl + & (Or Ctrl + Shift + 6): Places exterior (thin) border around current selection