Microsoft Excel Keyboard Shortcuts
Excel rewards keyboard fluency more than almost any other Office app, because a single workbook can demand thousands of repetitive actions: filling formulas down a column, jumping between sheets, formatting cells, or auditing a model for errors. Mouse-driven users tend to plateau at a fairly slow pace because every click requires re-locating the ribbon, while keyboard-driven users can keep their eyes on the data the entire time. The shortcuts below are grouped by what you're actually trying to do — get around a large sheet, enter and edit data without breaking flow, format cells quickly, and work with the structural stuff like rows, sheets, and pivot tables. Windows and Mac diverge more in Excel than in most other Microsoft products, largely because Mac Excel inherited some legacy Apple conventions (like Cmd+T conflicting with Spotlight on some setups) and because the Windows version still carries the Lotus 1-2-3 'old keys' compatibility layer (Alt is the menu-access key, not Option).
Navigation
| Action | Windows | Mac | Description |
|---|---|---|---|
| Jump to cell A1 | Ctrl+Home | Cmd+Home (or Fn+Ctrl+Left) | Sends the active cell to A1 regardless of where you are in the sheet, which is the fastest way to reorient yourself after scrolling deep into a large dataset. |
| Jump to last used cell | Ctrl+End | Cmd+End (or Fn+Ctrl+Right) | Moves to the bottom-right corner of the sheet's used range — useful for spotting stray formatting or data far outside your visible table. |
| Jump to the edge of a data region | Ctrl+Arrow key | Cmd+Arrow key | Skips to the last non-empty cell in that direction before hitting a blank, or the next non-empty cell if you're starting on a blank. This is the single most useful navigation shortcut for tables with thousands of rows. |
| Switch to next/previous worksheet | Ctrl+PgDn / Ctrl+PgUp | Fn+Option+Down / Fn+Option+Up (or Ctrl+PgDn/PgUp) | Cycles through sheet tabs without touching the mouse, which matters a lot in workbooks with a dozen or more tabs. |
| Open Go To dialog | Ctrl+G or F5 | Cmd+Fn+F5 or Control+G | Lets you type a cell reference or named range to jump straight there, and combined with Special… it can select all formulas, blanks, or conditional formats in one move. |
| Select current data region | Ctrl+Shift+8 | Cmd+Shift+8 | Grabs the whole contiguous block of data touching the active cell in every direction, expanding outward until it hits an empty row or column on all sides — one keystroke instead of chaining several Ctrl+Shift+Arrow presses or dragging manually. |
| Freeze panes at current selection | Alt+W, F, F (ribbon access keys) | View menu > Freeze Panes | Locks rows and/or columns above and to the left of the active cell so they stay visible while scrolling through the rest of the sheet, commonly used to keep header rows or a leftmost label column always in view. |
Data Entry Editing
| Action | Windows | Mac | Description |
|---|---|---|---|
| Fill down | Ctrl+D | Cmd+D | Copies the content and formula of the top cell in a selection down through the rest of it — faster than copy-paste when you've already selected the target range. |
| Fill right | Ctrl+R | Cmd+R | Same as fill down but horizontally; handy for dragging a formula across monthly columns. |
| AutoSum | Alt+= | Shift+Cmd+T | Drops in a SUM formula and takes its best guess at which adjacent cells belong in the range. That guess is genuinely just a guess, not magic, so it's worth double-checking the highlighted range before hitting Enter, especially near merged cells or existing subtotal rows. |
| Repeat last action | F4 or Ctrl+Y | Cmd+Y or Fn+F4 | Reapplies whatever you just did — inserting a row, applying bold, deleting a column — without reopening any dialog. Extremely useful when formatting many non-adjacent cells one at a time. |
| Edit the active cell | F2 | Control+U or Fn+F2 | Drops you into in-cell editing mode at the end of the existing content, equivalent to double-clicking the cell, without risking an accidental drag. |
| Insert current date | Ctrl+; | Ctrl+; | Stamps today's date as a static value (not a live formula like TODAY()), so it won't change when the file is reopened later. |
| Insert current time | Ctrl+Shift+; | Cmd+Shift+; | Same idea as the date shortcut but for the current time, also a static value rather than a formula. |
| Undo last action | Ctrl+Z | Cmd+Z | Reverts the most recent action, with Excel maintaining a deep undo history covering typed entries, formatting changes, row/column operations, and most other edits in the order they were performed. |
| Clear cell contents | Delete | Delete or Backspace | Clears the value or formula from the selected cell(s) without removing any formatting applied to them, distinct from Ctrl+Minus which removes the row/column structure itself entirely. |
Formulas
| Action | Windows | Mac | Description |
|---|---|---|---|
| Show formulas instead of results | Ctrl+` | Ctrl+` | Flips the entire sheet over to showing raw formula text instead of the values they compute, a quick way to scan a whole model for broken references or leftover copy-paste mistakes before handing it off. |
| Toggle absolute/relative reference | F4 | Cmd+T or Fn+F4 | While editing a formula with the cursor next to a cell reference, cycles through $A$1, A$1, $A1, and A1. Saves you from manually typing dollar signs every time you need to lock a reference before filling a formula across a range. |
| Confirm an array/legacy CSE formula | Ctrl+Shift+Enter | Cmd+Shift+Enter | Required for legacy array formulas (pre-dynamic-array Excel) to evaluate correctly; modern Excel with dynamic arrays often doesn't need this anymore, but it's still necessary in older file formats or with certain legacy functions. |
| Open Insert Function dialog | Shift+F3 | Shift+Fn+F3 | Opens the guided function builder, useful when you know roughly what you want (e.g. a lookup) but not the exact syntax or argument order. |
| Trace precedents | Ctrl+[ | Cmd+[ (varies by version) | Highlights and selects every cell that feeds directly into the currently active formula, letting you trace a calculation chain by hand without clicking through the Formulas ribbon's arrow-drawing tool. |
| Recalculate entire workbook | F9 | Cmd+= or Fn+F9 | Forces Excel to recalculate every formula in every open workbook, necessary when calculation mode is set to Manual rather than Automatic, or when a stubborn formula appears stuck showing a stale value despite dependent cells having changed. |
| Step through formula evaluation | Formulas tab > Evaluate Formula, no default key | Same | Opens a dialog that lets you step through a complex formula's evaluation one calculation at a time, showing exactly what each nested function or reference resolves to at each stage, useful for debugging a deeply nested formula that isn't producing the expected result. |
Formatting
| Action | Windows | Mac | Description |
|---|---|---|---|
| Toggle bold | Ctrl+B | Cmd+B | Standard across Office, applies to the selected cells' text. |
| Open Format Cells dialog | Ctrl+1 | Cmd+1 | Opens the full formatting dialog (number format, borders, fill, alignment) in one keystroke instead of hunting through ribbon tabs — arguably the highest-value single shortcut in Excel for anyone doing serious formatting work. |
| Apply currency format | Ctrl+Shift+$ | Cmd+Shift+$ | Quickly formats selected cells as currency with two decimal places, without opening the Format Cells dialog. |
| Apply percentage format | Ctrl+Shift+% | Cmd+Shift+% | Formats the selection as a percentage with no decimal places — note it does not multiply the underlying value, so a cell showing 0.5 becomes 50%, not 0.5%. |
| Add outline border | Ctrl+Shift+& | Cmd+Option+0 | Draws a border around the selected range without opening the border picker, useful when boxing off a summary table quickly. |
| Clear formatting | Alt+H, E, F (no single default key) | no default; assignable | Excel has no single dedicated key for this by default in either OS — most people use the Home ribbon's Clear > Clear Formats, or assign a custom shortcut via Quick Access Toolbar. Worth knowing it's not a built-in gap in your memory; it genuinely isn't bound. |
| Toggle italic | Ctrl+I | Cmd+I | Applies or removes italic formatting on the selected cells' text, standard across every Office application and consistent with the same shortcut in Word and PowerPoint. |
| Toggle text wrapping | Alt+H, W (ribbon access keys) | Format Cells > Alignment > Wrap text | Toggles whether text that's too long for a cell's width wraps onto multiple lines within that cell (increasing row height as needed) rather than overflowing visually into adjacent cells or getting cut off at the cell boundary. |
Rows Columns Sheets
| Action | Windows | Mac | Description |
|---|---|---|---|
| Insert row | Ctrl+Plus (with a full row selected, or Ctrl+Shift+= otherwise) | Cmd+Shift+= or Cmd+I | If an entire row is selected it inserts a row above; if only cells are selected it opens the Insert dialog asking whether to shift cells right or down. |
| Delete row | Ctrl+Minus | Cmd+Minus | Deletes the selected row(s) entirely when a full row is selected; otherwise opens a dialog to choose what shifts to fill the gap. |
| Select entire row | Shift+Space | Shift+Space | Selects the full row of the active cell, the precursor to most insert/delete/format-row operations done by keyboard. |
| Select entire column | Ctrl+Space | Ctrl+Space | Selects the full column of the active cell. On Mac, Ctrl+Space can be intercepted by Spotlight or an input-source switcher depending on system settings, in which case it silently does nothing in Excel until you disable that OS shortcut. |
| Group rows/columns (outline) | Shift+Alt+Right | Cmd+Shift+K | Creates a collapsible outline group from the selected rows or columns, the same feature accessed via Data > Group, useful for collapsing detail rows under subtotals. |
| Insert PivotTable | Alt+N, V (ribbon access key sequence) | no default keyboard shortcut | There's no single hotkey for this in either OS by default; on Windows the Alt key reveals ribbon access-key letters you can chain (Alt then N then V) which is faster than it sounds once memorized, but Mac users are stuck using the Insert menu or the mouse. |
| Insert new worksheet | Shift+F11 | Shift+Fn+F11 | Adds a new blank sheet tab to the left of the active one, without right-clicking the tab bar. |
| Hide selected row(s) | Ctrl+9 | Cmd+9 | Hides the selected row(s) from view without deleting their content, useful for temporarily decluttering a sheet or hiding sensitive or irrelevant rows before sharing or presenting a workbook. |
| Unhide row(s) | Ctrl+Shift+9 | Cmd+Shift+9 | Restores visibility to hidden rows within the current selection, the direct counterpart to hiding, requiring the selection to span both above and below the hidden rows since a fully hidden row can't itself be directly selected by clicking. |
Frequently Asked Questions
Why does Ctrl+Shift+Enter still matter if Excel now has dynamic arrays?
Modern Excel (365) spills array results automatically without CSE, but you'll still hit it in two cases: files saved in .xls/legacy formats, and a handful of older functions that were never updated to support implicit dynamic-array behavior. If you open a workbook built years ago and a formula looks wrong after editing, try re-confirming it with Ctrl+Shift+Enter before assuming the formula itself is broken.
Why doesn't Ctrl+Space select my column on Mac?
macOS reserves Ctrl+Space system-wide for Spotlight or input source switching on many configurations, and that system-level binding intercepts the keystroke before Excel ever sees it. Go to System Settings > Keyboard > Keyboard Shortcuts and either disable or remap the Spotlight/input-source shortcut, or use Fn+Ctrl+Space as a workaround on some Mac models.
What's the fastest way to select a huge table without dragging?
Click one cell inside the table, then press Ctrl+Shift+8 (Windows) or Cmd+A (Mac, when inside a contiguous data block) to select the current region. For a single direction, Ctrl+Shift+Arrow extends the selection to the edge of the data in that direction, which is more controlled than the 'select all' shortcut when your sheet has multiple tables.
Is there a shortcut to merge cells?
Not by default on either platform — Merge & Center lives only on the ribbon or Quick Access Toolbar unless you record and bind your own macro to a key. It surprises a lot of longtime users who assume every ribbon button secretly has a keyboard equivalent hiding somewhere; this one genuinely doesn't.
Why does Ctrl+1 sometimes not open Format Cells?
If you're inside cell-edit mode (after pressing F2 or double-clicking), Ctrl+1 types the literal number 1 rather than opening the dialog, because the keystroke is being captured by the text cursor instead of the application. Press Escape first to leave edit mode, then Ctrl+1 works as expected.