Excel Row, Column & Sheet Management Shortcuts
Restructuring a spreadsheet — inserting a row, deleting a column, adding a new sheet tab, grouping rows into a collapsible outline — happens constantly while building or cleaning up a workbook, and doing it from the keyboard avoids the small but real risk of right-clicking the wrong row entirely and deleting data you meant to keep. Rounding out row and column management, hiding and unhiding rows lets you temporarily declutter a sheet or conceal sensitive content without deleting it outright, complementing the insert, delete, and grouping shortcuts covered above.
| 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. |
Selecting a full row or column first changes what the insert/delete shortcuts do. Shift+Space selects the entire row of the active cell, and Ctrl+Space selects the entire column. With a full row selected, Ctrl+Plus (the equals/plus key, often written Ctrl+Shift+= since Plus requires Shift on most keyboards) inserts a new row above the selection instantly, no dialog. If instead you only have a range of cells selected rather than a full row, the same shortcut opens an Insert dialog asking whether to shift the surrounding cells right or down — a useful safety check, but one extra step compared to having pre-selected the whole row.
Ctrl+Minus deletes the selected row or column outright when a full row/column is selected, or opens a Delete dialog with shift options when only cells are selected, mirroring the insert behavior. On Mac, the same keys (Cmd+Plus / Cmd+Minus, sometimes shown as Cmd+I for insert) apply, though older Mac keyboard layouts occasionally require Fn in combination depending on whether the Plus/Minus keys are on the numeric keypad or the top row.
Switching and creating sheets by keyboard matters once a workbook grows past a handful of tabs. Shift+F11 inserts a new blank worksheet to the left of the currently active one — faster than right-clicking the tab bar and choosing Insert, especially if you're adding several sheets in a row (e.g., one tab per month). Ctrl+PgUp and Ctrl+PgDn cycle between existing tabs without touching the mouse at all, which saves real time once a workbook has more tabs than fit visibly across the bottom bar and you'd otherwise be scrolling the tab strip to find the right one.
Grouping (Shift+Alt+Right on Windows, Cmd+Shift+K on Mac) creates a collapsible outline from selected rows or columns — the same structure you'd get from Data > Group — letting you collapse detail rows under a subtotal with a single click on the resulting outline symbol. This is distinct from simply hiding rows: grouped rows show a visible +/− control so anyone opening the file later knows there's hidden detail available, whereas manually hidden rows give no visual indication at all.
PivotTables have no default keyboard shortcut to insert in either Windows or Mac Excel. On Windows you can get close using the ribbon access-key sequence (press Alt to reveal letter overlays, then N for Insert tab, then V for PivotTable), which with practice is nearly as fast as a dedicated hotkey, but Mac users genuinely have no keyboard path and must use the Insert menu.
Hiding selected rows (Ctrl+9 / Cmd+9) removes them from view entirely without deleting any of their actual content — the underlying data, formulas, and formatting all remain fully intact, simply not displayed, which is meaningfully different from deleting a row and useful for temporarily decluttering a sheet during a presentation, or deliberately concealing sensitive rows (like individual salary figures within a summarized budget) before sharing a workbook more broadly.
Unhiding rows (Ctrl+Shift+9 / Cmd+Shift+9) reverses this, though it requires a specific selection technique since a fully hidden row can't be clicked on directly the way a visible one can — selecting the visible rows immediately above and below the hidden range (so the selection spans across the hidden rows without needing to click on them specifically) and then triggering unhide restores visibility to everything within that span. This distinction between hiding (reversible, content-preserving) and deleting (destructive, permanent) is worth keeping firmly in mind, since the two solve genuinely different problems despite both making rows disappear from the visible sheet.