Excel Shortcuts Cheat Sheet

Why Shortcuts Are the Highest-ROI Keyboard Skill

Every time your hand leaves the keyboard to reach for the mouse, you lose roughly 2 seconds of flow. Multiply that by hundreds of operations per day and the productivity drain is staggering. Excel keyboard shortcuts don't just save time β€” they keep you in a fluid state where your thoughts translate directly into spreadsheet manipulation, without the friction of menu hunting.

This cheatsheet is organized by usage frequency, not alphabetically. Master the Essentials section and you're already faster than 80% of Excel users. Add Intermediate shortcuts and you're faster than 95%. The Advanced section is what makes you look like a magician in front of colleagues.

Excel keyboard shortcut reference sheet arranged in a clean grid layout. Three sections: Essentials (Ctrl+S, C, V, Z, arrows, Home/End), Intermediate (Ctrl+T, Shift+L, Alt+=, Ctrl+1, F2, F4, PgUp/PgDn), Advanced (Ctrl+Shift+Plus/Minus, Ctrl+D/R, Alt+Enter, Ctrl+[/]). Each shortcut has a one-line description and a visual keyboard key icon.
Fig 1. β€” The complete shortcut reference at a glance. Print this and keep it next to your monitor. Looking at the reference when you forget beats reaching for the mouse every time.

Essentials: Learn These First

Navigation β€” Move without the mouse

  1. Ctrl + Arrow Keys β€” Jump to the edge of the data region. From the top of a column, Ctrl+Down jumps to the last filled cell. Add Shift to select along the way: Ctrl+Shift+Down.
  2. Ctrl + Home β€” Jump to cell A1. Ctrl + End β€” Jump to the last used cell. Essential for navigating large worksheets.
  3. Ctrl + PgUp / PgDn β€” Cycle through worksheet tabs left/right. Much faster than clicking tabs, especially in workbooks with 20+ sheets.

Universal commands β€” The muscle-memory foundation

  1. Ctrl + S β€” Save. Train yourself to reflexively press this every few minutes. Excel crashes; data loss is preventable.
  2. Ctrl + C / Ctrl + X / Ctrl + V β€” Copy, Cut, Paste. Universal across applications but the foundation of every Excel workflow.
  3. Ctrl + Z / Ctrl + Y β€” Undo and Redo. Excel's undo stack is deep β€” use it boldly. Redo restores what you just undid.

Intermediate: Daily Workhorses

Formatting and data operations

  1. Ctrl + T β€” Create an Excel Table from a data range. Tables auto-expand and enable structured references. If you learn ONE shortcut beyond copy-paste, learn this.
  2. Ctrl + Shift + L β€” Toggle filters on/off. Press once to add filter dropdowns to headers, again to remove. Never hunt through the Data tab again.
  3. Alt + = β€” AutoSum. Instantly inserts a SUM formula for adjacent data. Works for rows and columns. Excel guesses the range correctly ~95% of the time.
  4. Ctrl + 1 β€” Format Cells dialog. Opens the complete formatting dialog for the current selection β€” number, alignment, font, border, fill, protection. Much faster than right-click > Format Cells.
  5. F2 β€” Edit cell. Enters edit mode with the cursor at the end. Shift + F2 inserts or edits a comment.
  6. F4 β€” Two functions: (1) In a worksheet, repeats the last action (insert row, apply format, delete). (2) In the formula bar, cycles through absolute/relative references: A1 > $A$1 > A$1 > $A1 > A1.

Row and column shortcuts

  1. Shift + Space β€” Select entire row. Ctrl + Space β€” Select entire column.
  2. Ctrl + Shift + Plus (+) β€” Insert row/column (after selecting with above shortcuts). No right-click menu needed.
  3. Ctrl + Minus (-) β€” Delete row/column.
  4. Ctrl + 0 β€” Hide selected columns. Ctrl + Shift + 0 β€” Unhide.
  5. Ctrl + 9 β€” Hide selected rows. Ctrl + Shift + 9 β€” Unhide.

Advanced: Become the Office Excel Guru

  1. Ctrl + D / Ctrl + R β€” Fill Down / Fill Right. Copies the top or leftmost cell to the selected range. Massive time-saver for applying formulas to entire columns.
  2. Alt + Enter β€” Line break inside a cell. Start a new line without exiting edit mode. Essential for readable multi-line headers and notes.
  3. Ctrl + ` (backtick) β€” Toggle between showing formula results and formula text. Invaluable for auditing and understanding complex workbooks.
  4. Ctrl + [ / Ctrl + ] β€” Trace precedents/dependents. Jump to the cells that feed the current formula, or to formulas that depend on the current cell. Ctrl+G > Special also opens the Go To Special dialog.
  5. Alt key sequences β€” Press Alt once, and Excel shows key tips for every Ribbon tab and command. Alt+H+O+I auto-fits column width. Alt+N+V inserts a PivotTable. These sequences are longer but cover every command in Excel.

Common Mistakes

  1. Trying to learn too many at once. Pick 3-5 new shortcuts per week and use them consciously until they become muscle memory. Trying to memorize 50 at once guarantees you'll forget 45.
  2. Grabbing the mouse "just this once." Every time you reach for the mouse for an action that has a keyboard shortcut, you delay muscle memory formation. Stop, recall the shortcut, use it. The initial friction is the price of long-term speed.
  3. Not printing the cheatsheet. Keep a printed reference next to your monitor. When you forget, glance at the sheet rather than grabbing the mouse. You'll internalize faster.
  4. Not customizing Quick Access Toolbar. Add your most-used commands to the QAT. Trigger them with Alt+1, Alt+2, etc. Paste Values, Format Painter, and Save As are excellent QAT additions.

Advanced Tips

Download Practice Template
Have questions or found an error in this article?