Home

Consulting

Excel VBA

Legal

Links

Contact

About Us

Excel Shortcuts

If you don't use the shortcuts you are wasting valuable time. Below is list of some of the useful shortcuts:
  • Shift F11 = New Sheet
  • Ctrl F3 = Names Dialog
  • Ctrl G = Go to dialog
  • Alt I C = Insert Column
  • Alt I R = Insert Row
  • Ctrl PgDn = Next Sheet
  • Ctrl PgUp = Prev Sheet
  • F7 = Spell check
  • Ctrl $ = Format in $
  • Ctrl Shift 8 = Select a Region
  • Ctrl Arrow = Takes you to the end of a Region
  • Ctrl F6 = Next Excel Window
  • Alt F11 = Autosum
  • Shift F3 = Insert Function Dialog
  • Alt F8 = Macro Dialog
  • F2 = Edit Cell
  • F4 = Toggles cell from Relative Addressing to Absolute Addressing
  • Ctrl F = Find Dialog
  • Shift Arrow key= Select a range
  • Crlt Arrow key = Select an Area
  • F9 = Recalc
  • Ctrl Arrow key = Next or Prev word in Edit mode
  • Turn on Fitlers = Alt D F F
  • Ctrl K = Set a hyperlink

VBA Shortcuts

  • Ctrl G = Immediate Window
  • F5 = Run
  • F8 = Step
  • Shift F8 = Step over routine
  • Ctrl Shift F8 = Step out of routine
  • F4 = Properties

Windows

  • Alt Tab = Next Window
  • Windows key - D = Show Desktop
  • Ctrl C = Copy to clipboard
  • Ctrl V = Paste from clipboard
  • Ctrl X = Cut to clipboard
  • Ctrl Z = Undo
  • Ctrl A = Select All
  • F5 = Refresh
  • F1 = Help