In Excel: press Shift+Space on Windows (Shift+Space on Mac) to select the whole row instantly — no mouse or menu required.
Keyboard shortcut: Select Row
| Platform | Shortcut |
|---|---|
| Windows | Shift+Space |
| Mac | Shift+Space |
Selects the entire row of the active cell.
Click the target cell, row header, or column header so Excel knows what to act on.
Hold the modifier key(s) in Shift+Space (Windows) or Shift+Space (Mac) simultaneously, then tap the final key.
Excel executes the Select Row operation instantly.
Undo with Ctrl+Z (⌘+Z on Mac) if the result is not what you expected.
What this does
The Select Row shortcut lets you select the whole row in Excel without touching the mouse. Press Shift+Space on Windows (Shift+Space on Mac) and Excel acts immediately — no right-click, no ribbon hunt. Keeping your hands on the keyboard for the Select Row operation cuts context-switching overhead and keeps you in a data-entry flow that menu clicks constantly interrupt. Once Shift+Space becomes muscle memory you will reach for it instinctively whenever you need to select the whole row. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “excel select row shortcut”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected rows change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Practical use: you are cleaning a dataset and need to select the whole row multiple times. Select your target, hit Shift+Space on Windows (Shift+Space on Mac) for the first Select Row action, then press F4 to repeat the last action at each subsequent selection — this chains the Shift+Space shortcut into a rapid-fire workflow that beats any menu approach. The Select Row shortcut pays off most when you are doing repetitive structural edits — adding or removing rows, navigating large datasets, or reformatting ranges. Pressing Shift+Space once may feel marginal, but chaining it with navigation keys (arrow keys, Ctrl+arrow) creates a fully keyboard-driven workflow that dramatically outpaces mouse-heavy editing. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “excel select row shortcut”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Pressing the wrong modifier: Shift+Space is the Windows combo; on Mac the equivalent is Shift+Space. Pressing the Windows combo on Mac often does nothing or triggers a different command.
- Not selecting a full row/column header when the shortcut requires it — some shortcuts act on selected rows or columns, not on individual cells.
- Forgetting that the shortcut may behave differently depending on what is selected: a cell selection vs a row-header selection can invoke different dialog boxes for the same keypress.
Frequently asked questions
Is there a Mac shortcut for Select Row?
Yes — on Mac use Shift+Space. The function is identical to pressing Shift+Space on Windows; only the modifier keys differ because Mac replaces Ctrl with ⌘ and sometimes Alt with Option (⌥).
What if the Select Row shortcut (Shift+Space) doesn't work?
Check that you are not in cell-edit mode (press Escape first), that no dialog is open, and that no add-in has reassigned the shortcut. On a laptop, some function keys require pressing Fn first.
Can I use the Select Row shortcut multiple times in a row?
Yes — press Shift+Space repeatedly for each Select Row action, or pre-select multiple rows/columns and press the shortcut once to apply it to all of them simultaneously. You can also press F4 after the first use to repeat the last action.
Other ways people ask this
This is also commonly searched as “excel shortcut select row”, “excel shortcut to select row”, “shortcut to select rows in excel” and “select rows shortcut excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Is there a keyboard shortcut for this?
Yes — “excel select row shortcut” is one key combination away rather than a trip through the menus. Use the Windows/Mac toggle above to see the exact keys for your machine, and remember Ctrl on Windows maps to ⌘ on Mac.
Why do people search for this in so many different ways?
Because the same task has many names. “excel shortcut select row”, “excel shortcut to select row”, “shortcut to select rows in excel” all point at the one operation explained on this page, which is why they all lead here.