Microsoft Excel — Keyboard Shortcuts (Leveled)
Shortcuts below are for Windows Excel (desktop). On Mac, use ⌘ where you see Ctrl for many commands; ⌥ ≈ Alt. Ribbon keys after Alt are sequence taps (not held together).
Tip: Press Alt once to show KeyTips on the ribbon; letters appear on each tab and command.
Completeness: Excel has hundreds of shortcuts; keys differ by version (e.g. Microsoft 365 vs older), language/locale (ribbon letters change), context (chart, PivotTable, editing in cell), and add-ins. No static HTML page can list literally every assignment. This file covers standard Windows desktop Excel shortcuts; for your exact build, use Alt + Q (Tell me) or Microsoft’s official “Keyboard shortcuts in Excel” article.
Common — everyday (everyone should know)
| Shortcut | Action | Detail |
|---|---|---|
| Ctrl + S | Save | Saves workbook. Use F12 for Save As. |
| Ctrl + O | Open | Open file dialog. |
| Ctrl + N | New workbook | New blank workbook. |
| Ctrl + P | Print preview / print dialog. | |
| Ctrl + Z / Ctrl + Y | Undo / Redo | Multiple levels of undo (depending on options). |
| Ctrl + C / Ctrl + X / Ctrl + V | Copy / Cut / Paste | Ctrl + Shift + V opens Paste Special (Excel 365). |
| Ctrl + F | Find | Find in sheet; Ctrl + H = Replace. |
| F2 | Edit active cell | Enters edit mode; cursor inside cell. |
| Enter / Ctrl + Enter | Confirm / fill selection | Ctrl + Enter fills all selected cells with same value. |
| Esc | Cancel | Exit edit mode without saving; cancel dialog. |
| Ctrl + A | Select all | In a block: expands to current region; second press = entire sheet. |
| Ctrl + Arrow | Jump to edge | Moves to boundary of contiguous data region. |
| Shift + Arrow | Extend selection | One cell at a time. |
| Ctrl + Shift + Arrow | Select to edge | Selects to end of data block in that direction. |
| Ctrl + Home / Ctrl + End | A1 / last used | Ctrl + End moves to last used cell in sheet. |
| Ctrl + W | Close workbook | Closes active file; prompts to save if needed. |
| Alt + F4 | Close Excel | Closes application (all windows). |
| F12 | Save As | Open Save As dialog. |
| Shift + F10 | Context menu | Right-click menu for selection (same as Application key). |
Beginner — navigation & formatting basics
| Shortcut | Action | Detail |
|---|---|---|
| Tab / Shift + Tab | Next / previous cell | Within selection; moves right/left. |
| Home | Start of row | Column A of current row (unless Scroll Lock). |
| Ctrl + Page Down / Page Up | Next / previous sheet | Switches worksheet tabs. |
| Alt + Page Down / Alt + Page Up | Move one screen right/left | Horizontal scroll by window width. |
| Shift + Space | Select entire row | Full row of active cell. |
| Ctrl + Space | Select entire column | Full column of active cell. |
| Ctrl + B / I / U | Bold / Italic / Underline | Toggle font style. |
| Ctrl + 1 | Format Cells | Opens dialog (Number, Alignment, Font, Border, Fill, Protection). |
| Ctrl + ; | Today’s date | Static date; not volatile. |
| Ctrl + Shift + ; | Current time | Static time. |
| Ctrl + Shift + # | Date format | Applies date format to selection. |
| Ctrl + Shift + $ | Currency | Two decimals. |
| Ctrl + Shift + % | Percent | No decimals by default. |
| Alt + = | AutoSum | Inserts SUM in adjacent cell or status bar. |
| Ctrl + D / Ctrl + R | Fill down / right | Copies top/left cell of selection into rest. |
| Ctrl + Shift + ~ | General format | Removes other number formatting (General). |
| Ctrl + Shift + ! | Number (2 decimals) | Comma separators; two decimal places. |
| Ctrl + Shift + @ | Time format | Time display for selection. |
| Ctrl + 5 | Strikethrough | Toggles strikethrough font. |
| Ctrl + Shift + * | Select current region | Data block around active cell (asterisk on main keypad). |
| Page Down / Page Up | Screen vertically | One screen up/down (see also Alt+PgDn/PgUp for horizontal). |
| End then Arrow | End mode + jump | Press End (status “End” on), then arrow moves like Ctrl+Arrow. |
| End, Home | End mode: row start | Moves to start of row (with End mode). |
| End, Enter | Move in direction | After End, moves per Move selection after Enter setting. |
| Shift + F11 | New worksheet | Inserts new sheet tab. |
| Ctrl + Shift + Page Down / Up | Select adjacent sheets | Group sheets for editing. |
Intermediate — data, filters, names, sheets
| Shortcut | Action | Detail |
|---|---|---|
| Ctrl + T | Insert Table | Convert range to Excel Table (structured references). |
| Ctrl + Shift + L | Toggle filters | AutoFilter on/off for header row. |
| Alt + ↓ | Filter dropdown | Opens filter menu for column of active cell. |
| Alt + A + M | Remove Duplicates | Data tab: ribbon sequence (Alt, then A, then M). |
| Ctrl + Shift + + | Insert cells / rows / columns | Dialog or insert per selection context. |
| Ctrl + - | Delete cells / rows / columns | Opens delete dialog. |
| Ctrl + ' | Copy formula from above | Copies formula only (same row reference). |
| Ctrl + Shift + " | Copy value from above | Copies value from cell above. |
| F4 | Repeat / lock references | Repeats last action; in formula bar cycles $A$1, A$1, $A1, A1. |
| Ctrl + ` (grave) | Show formulas | Toggle display formulas vs values (sheet-wide). |
| Ctrl + [ | Trace precedents | Selects cells that feed into active cell formula. |
| Ctrl + ] | Trace dependents | Selects cells that depend on active cell. |
| Ctrl + G | Go To | Jump to named range, cell reference, special. |
| F5 | Go To | Same as Ctrl+G. |
| Ctrl + F3 | Name Manager | Define/edit named ranges. |
| Shift + F3 | Insert Function | Function wizard dialog. |
| Ctrl + Shift + U | Expand/collapse formula bar | More room for long formulas. |
| Alt + E + L | Delete sheet | Legacy sequence (context menu Delete Sheet). |
| Ctrl + K | Insert hyperlink | Link to URL, file, place in document. |
| Ctrl + Shift + Space | Select entire table | When active cell is inside an Excel Table: selects whole table. |
| F7 | Spelling | Spell check. |
| Shift + F7 | Thesaurus | Research / Thesaurus (if available). |
| Ctrl + Shift + F | Format Cells | Opens Format Cells dialog (many builds; same family as Ctrl+1). |
| Alt + Q | Tell me | Search commands (“Tell me what you want to do”). |
| Ctrl + F1 | Show/hide ribbon | Collapses or expands the ribbon. |
| F5 → Alt + S | Go To Special | In Go To dialog, Special opens constants, blanks, objects, etc. |
| Alt + H + F + I | Fill menu | Home → Fill (then choose Down/Series/Across per submenu; ribbon letters locale-dependent). |
Advanced — PivotTables, charts, objects, special paste
| Shortcut | Action | Detail |
|---|---|---|
| Alt + N + V | Insert PivotTable | Ribbon: Insert → PivotTable (sequence). |
| Alt + J + T | PivotTable Analyze (when focused) | Contextual tab keytips when PivotTable selected. |
| Alt + F1 | Chart embedded | Default chart on current sheet. |
| F11 | Chart new sheet | Creates chart on new sheet. |
| Ctrl + Shift + F | Font dialog | Extended font formatting. |
| Alt + E + S | Paste Special | Classic sequence; or Ctrl + Alt + V in many versions. |
| Ctrl + Alt + V | Paste Special | Values, formats, transpose, operations, etc. |
| Ctrl + Shift + V | Paste values only | Excel 365 / Microsoft 365 shortcut. |
| Alt + H + V + V | Paste values (ribbon) | Home → Paste → Values sequence. |
| Ctrl + Shift + & | Outline border | Outside border on selection. |
| Ctrl + Shift + _ | Remove outline border | Clears borders. |
| Ctrl + 9 / Ctrl + 0 | Hide row / column | Hide selected rows or columns. |
| Ctrl + Shift + 9 / ( | Unhide rows / columns | Unhide hidden rows/columns in selection. |
| Ctrl + 8 | Toggle outline symbols | If grouping/outline applied. |
| Alt + Shift + → / ← | Group / Ungroup | Rows or columns (with data). |
| Ctrl + Shift + L | Table filter | Same as AutoFilter; with table = filter row. |
| Alt + M + E | Flash Fill | Data tab: Flash Fill (pattern detection). |
| Ctrl + E | Flash Fill | Excel 365: quick fill when pattern detected. |
Expert / power user — names, macros, windows, audit
| Shortcut | Action | Detail |
|---|---|---|
| Alt + F8 | Macro dialog | Run, edit, step into macros. |
| Alt + F11 | VB Editor | VBA editor for workbooks, modules, UserForms. |
| Ctrl + Shift + F3 | Create names from selection | Top row / left column as range names. |
| F9 | Recalculate | Recalculate all worksheets (manual calc mode). |
| Shift + F9 | Recalculate active sheet | Faster than full workbook. |
| Ctrl + Alt + F9 | Full rebuild | Forces full recalculation of all formulas. |
| Ctrl + Shift + U | Formula bar expand | Toggle multi-line formula bar. |
| Ctrl + Shift + { | Select all precedents | All direct dependents of selection (array variants exist). |
| Ctrl + Shift + } | Select all dependents | Cells that depend on selection. |
| Ctrl + Shift + Z | Redo (some setups) | Alternate redo; often Ctrl + Y is primary. |
| Alt + F + T | Excel Options | File → Options. |
| Ctrl + Shift + P | Font dialog (legacy) | May open font in some contexts. |
| Ctrl + F6 | Next workbook window | Switch between open Excel windows. |
| Ctrl + Shift + F6 | Previous workbook window | Reverse order. |
| Ctrl + F7 | Move window | Arrow keys to move (when not maximized). |
| Ctrl + F9 | Minimize workbook | Minimize workbook window. |
| Ctrl + F10 | Maximize/restore | Workbook window. |
| Ctrl + Tab / Ctrl + Shift + Tab | Next / previous workbook | Among open workbooks. |
| Alt + W + F | Freeze Panes | View tab: Freeze Panes. |
| Alt + W + V | Split | Split panes. |
| Ctrl + Shift + O | Select all comments | Selects cells with notes/comments. |
| Shift + F2 | Edit cell comment | Insert or edit note/comment. |
| Ctrl + Shift + A | Insert argument names | In function wizard, inserts placeholder names. |
| F9 (in formula bar) | Evaluate part | Select part of formula + F9 to evaluate (careful: permanent). |
| Ctrl + Shift + Enter | Legacy array formula | Older Excel: CSE array formulas. Dynamic arrays in 365 reduce need. |
Quick reference — selection & editing
- Ctrl + Shift + 8 — Select current region (same as Ctrl + A once in block).
- Ctrl + . — Cycle corners of selection (when multiple cells selected).
- Shift + F8 — Add to selection (multi-range selection mode).
- Ctrl + Backspace — Scroll to active cell (when off-screen).
- Ctrl + Delete — Delete to end of line (in formula bar).
- Alt + Enter — Line break inside cell (wrap text).
Quick reference — ribbon & accessibility
- Alt — KeyTips; then follow letters (e.g. Alt, H for Home).
- Ctrl + Shift + F — Font dialog (full formatting).
- F10 — Activate menu bar / ribbon keytips.
- Ctrl + Shift + F12 — Print (legacy in some versions).
Extended reference — function keys, names, calculation, objects
Use this section as a checklist. Keys marked context apply only in that mode (e.g. chart selected, editing cell).
| Shortcut | Action | Notes |
|---|---|---|
| F1 | Help | Excel Help pane. |
| F1 (in dialog) | Help for dialog | Context-sensitive help when a dialog is open. |
| F2 | Edit cell | Also positions caret in formula bar if editing there. |
| F3 | Paste name | While entering a formula: insert a defined name. |
| Shift + F3 | Insert Function | Function Arguments wizard. |
| Ctrl + Shift + F3 | Create names from selection | Row labels / column labels as names. |
| F4 | Repeat last action | Also cycles absolute/relative references in formulas. |
| Ctrl + F4 | Close workbook | Same as Ctrl+W in many setups. |
| Alt + F4 | Quit Excel | Close application. |
| F5 | Go To | Jump to reference or name. |
| Ctrl + G | Go To | Same as F5. |
| F6 | Next pane | Splits, workbook windows, window parts (context). |
| Shift + F6 | Previous pane | Reverse cycle. |
| F7 | Spelling | Spell check active sheet / selection. |
| Shift + F7 | Thesaurus / Research | Depends on version / add-ins. |
| F8 | Extend selection | Turns on extend mode; arrow keys enlarge selection. |
| Shift + F8 | Add to selection | Non-adjacent ranges (like Ctrl+click behavior via keyboard). |
| F9 | Calculate | Recalculates all workbooks (respects calc mode). |
| Ctrl + Alt + F9 | Calculate all | Full recalculation of all formulas in all open workbooks. |
| Ctrl + Alt + Shift + F9 | Rebuild + dependents | Rechecks dependent formulas, then full calculation. |
| F10 | Menu bar / KeyTips | Activates ribbon keytips (similar to Alt). |
| Shift + F10 | Context menu | Same as right-click. |
| F11 | Chart on new sheet | Default chart type. |
| Shift + F11 | New worksheet | Inserts sheet. |
| Alt + F11 | Visual Basic Editor | VBA environment. |
| F12 | Save As | Save under new name / location. |
| Ctrl + Shift + F12 | Opens Print (some versions). |
More formatting & alignment (standard)
- Ctrl + Shift + ^ — Scientific notation.
- Ctrl + Shift + & — Outside border (already in Advanced).
- Ctrl + Shift + _ — Remove outline border.
- Alt + H + A + C — Align center (Home → Alignment; English ribbon).
- Alt + H + A + L — Align left.
- Alt + H + A + R — Align right.
- Alt + H + O + I — AutoFit column width.
- Alt + H + O + A — AutoFit row height.
- Alt + H + O + U + C — Hide columns (Home → Format → Hide & Unhide).
- Alt + H + O + U + R — Hide rows (same menu).
Data & review (ribbon — English KeyTips)
- Alt + A — Data tab, then follow KeyTips (Get Data, Sort, Filter, Text to Columns, etc.).
- Alt + R — Review tab (Spelling, Protect Sheet, Comments).
- Alt + W — View tab (Freeze Panes, Zoom, New Window).
- Alt + P — Page Layout tab (margins, print area).
- Alt + M — Formulas tab (often; verify on your ribbon).
- Alt + N — Insert tab (tables, charts, pictures).
While editing a formula (cell or formula bar)
- Tab / Shift + Tab — Pick from autocomplete list; move between arguments.
- F4 — Cycle $A$1, A$1, $A1, A1 for reference under cursor.
- Ctrl + A — Formula Builder / Arguments dialog for function under cursor (context).
- Ctrl + Shift + Enter — Legacy array formula (pre–dynamic array Excel).
Charts & objects (selected object)
- Arrow keys — Nudge chart or object.
- Ctrl + Arrow — Smaller nudge.
- Alt + F1 — Default chart on sheet.
- Ctrl + C / Ctrl + V — Copy/duplicate chart (as object).
Quick tip
For large datasets, Alt + A + M (Remove Duplicates) and Ctrl + T (tables) plus Ctrl + Shift + L (filters) are high‑impact combos.
Practice
Pick one level per week, use shortcuts only (no mouse) for 15 minutes daily until muscle memory forms. Bookmark this page for PDF export.
Download ANSNEW APP For Ads Free Expriences!
Comments from Facebook