MS Excel Shortcut Keys

Here are more than 50 Microsoft Excel commands and shortcuts that are commonly used and can be helpful in an exam-oriented context:

Basic Navigation and Selection:

  • Move to the next cell: Tab or
  • Move to the previous cell: Shift + Tab or
  • Move to the next worksheet: Ctrl + Page Down
  • Move to the previous worksheet: Ctrl + Page Up
  • Select the entire row: Shift + Space
  • Select the entire column: Ctrl + Space
  • Select the entire worksheet: Ctrl + A
  • Select a range of cells: Click and drag, or Shift + Arrow keys
  • Extend the selection: Shift + Arrow keys

Editing and Formatting:

  • Cut: Ctrl + X
  • Copy: Ctrl + C
  • Paste: Ctrl + V
  • Undo: Ctrl + Z
  • Redo: Ctrl + Y or Ctrl + Shift + Z
  • Bold: Ctrl + B
  • Italic: Ctrl + I
  • Underline: Ctrl + U
  • Open Format Cells dialog: Ctrl + 1
  • Fill Down: Ctrl + D
  • Fill Right: Ctrl + R
  • Insert current date: Ctrl + ;
  • Insert current time: Ctrl + Shift + ;
  • Wrap text: Alt + Enter
  • AutoSum (Sum of selected cells): Alt + =
  • Hide selected rows or columns: Ctrl + 9 (for rows), Ctrl + 0 (for columns)
  • Show hidden rows or columns: Ctrl + Shift + ( (for rows), Ctrl + Shift + ) (for columns)

Formulas and Functions:

  • Insert a function: Shift + F3
  • AutoCalculate (sum, average, etc.): Alt + =
  • Edit a cell's formula: F2
  • Evaluate a formula: Alt + M, V, Enter (step through formula evaluation)
  • Absolute cell reference ($A$1): F4
  • Function arguments dialog: Ctrl + Shift + A
  • Insert function (new formula): Shift + F3
  • Name Manager: Ctrl + F3

Data Management:

  • Sort ascending: Alt + A, S, A
  • Sort descending: Alt + A, S, D
  • Filter: Ctrl + Shift + L
  • Remove filter: Alt + A, C
  • Data validation: Alt + D, L (open Data Validation dialog)
  • Text to Columns: Alt + D, E, F
  • Find: Ctrl + F
  • Replace: Ctrl + H

Cell and Worksheet Management:

  • Insert new worksheet: Shift + F11
  • Delete current worksheet: Alt + E, L
  • Hide/Unhide columns or rows: Ctrl + 8
  • Group/Ungroup worksheets: Shift + F11 (group), Alt + Shift + - (ungroup)

View and Zoom:

  • Zoom in: Ctrl + Scroll up or Ctrl + + (Plus key)
  • Zoom out: Ctrl + Scroll down or Ctrl + - (Minus key)
  • Full-screen mode: Ctrl + Shift + F1
  • Split worksheet: Alt + W, S (To split or remove split)

Please note that Excel shortcuts may vary depending on the version of Excel so read carefully before answering the question.