How to Select an Entire Row in Excel (Shift+Space)

Shift+Space selects the complete row of whichever cell is currently active, equivalent to clicking the row number on the left edge of the worksheet but without leaving the keyboard. This is the prerequisite step for most keyboard-driven row operations: inserting, deleting, hiding, or applying row-wide formatting. **Extending to multiple rows**: After selecting one row with Shift+Space, you can extend the selection to adjacent rows with Shift+Down or Shift+Up, building a multi-row selection entirely from the keyboard. This is faster than dragging across row headers with the mouse when you need to select, say, fifteen consecutive rows precisely. **What it enables**: With a full row selected, Ctrl+Plus inserts a new blank row immediately above without any dialog box appearing (because Excel already knows you want to insert a full row, not just shift some cells). Ctrl+Minus deletes the selected row(s) outright for the same reason. Without first selecting the full row — i.e., if you'd only selected a range of cells within that row — both shortcuts fall back to prompting you with an Insert or Delete dialog to confirm which direction neighboring cells should shift, an extra click that pre-selecting the entire row avoids entirely. **A subtlety with merged cells**: If any cell in the row is part of a merged cell that spans multiple rows, Shift+Space's behavior can look inconsistent, since Excel has to decide how to represent a row selection that partially includes a merge. This is one of several reasons experienced Excel users tend to avoid merged cells in any worksheet meant for serious data work — they interfere with several keyboard operations, not just this one. **Related shortcuts**: Ctrl+Space is the column equivalent, selecting the entire column of the active cell instead of the row. Ctrl+A, pressed once inside a contiguous data range, selects just that range (the 'current region'); pressed a second time, it extends to select the entire worksheet — different in scope from Shift+Space, which always targets exactly one row regardless of where data starts or ends. **When this matters**: Beyond insert/delete, selecting a full row by keyboard is also the fastest path to row-height adjustments, applying a fill color to flag a row for review, or copying an entire row (including all 16,384 columns' worth of formatting, even the ones you can't currently see) to paste elsewhere as a template row. **Mistake to avoid**: pressing Shift+Space while a full column (rather than a single cell) is already selected extends the selection down to include every row those columns intersect, which can unintentionally select the entire used range of the sheet if you weren't paying attention to what was selected beforehand — it's worth clicking a single cell first if you specifically want just one clean row selection. **Selecting a row that includes frozen columns**: if you've frozen the leftmost column or columns as headers, Shift+Space still selects the complete logical row across all columns, frozen or not, even though only the unfrozen portion of that selection is visible without scrolling — the selection itself is unaffected by which columns are currently frozen on screen. **A related but different action**: clicking directly on a row number in the worksheet's left margin achieves the identical selection with the mouse, and Ctrl+Click on additional row numbers extends that selection to non-adjacent rows, which is the mouse-driven equivalent of what Shift+Space plus Ctrl+Space combinations accomplish from the keyboard for building a multi-row, non-contiguous selection.