In Excel: Ctrl+Space selects the whole column, Shift+Space the whole row, Ctrl+A the current region, and Ctrl+Shift+↓ everything from the active cell to the bottom of the data.
Whole column: click a cell in it and press Ctrl+Space. Whole row: Shift+Space.
Surrounding block of data: Ctrl+A. Press it again for the entire worksheet.
To the edge of the data: Ctrl+Shift plus an arrow key; Ctrl+Shift+End goes to the last used cell.
Non-adjacent ranges: select the first, then hold Ctrl and select the others.
Long range without scrolling: click the first cell, type the last cell's address in the Name Box, and press Shift+Enter.
Only the visible cells of a filtered range: select it, then press Alt+; (Home ▸ Find & Select ▸ Go To Special ▸ Visible cells only).
What this does
Dragging works for ten rows and fails for ten thousand. The keyboard selections are what make large sheets workable, and they fall into three groups. Whole structures: Ctrl+Space for the column, Shift+Space for the row, Ctrl+A for the surrounding block of data (press it twice for the entire sheet). Extend-to-edge: Ctrl+Shift+arrow runs the selection to the last non-empty cell in that direction, which is how you grab a column of unknown length. And non-adjacent: hold Ctrl while clicking or dragging to add separate ranges to one selection, or Shift+click to extend from the active cell to wherever you click. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “select whole row in excel”. Start on a copy or a tiny sample, keep the affected rows visible, and compare the result with the tool above before you touch the real workbook. 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. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
To select the whole of column C, click any cell in it and press Ctrl+Space. To select A2 down to the last row of data, click A2 and press Ctrl+Shift+↓ — it stops at the first blank, so a gap in the column means pressing it twice. To select A2:D5000 in one move, click A2 and press Ctrl+Shift+End. To select three separate blocks and format them together, drag the first, then hold Ctrl and drag the other two. Every other operation starts with a selection, and the difference between dragging and Ctrl+Shift+arrow is the difference between a sheet you can work in and one you fight. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
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. The short version of “select whole row in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Dragging across thousands of rows when Ctrl+Shift+↓ does it instantly and does not overshoot.
- Expecting Ctrl+Shift+↓ to reach the bottom of the data when there are blank cells in between — it stops at the first gap.
- Copying a filtered range without Alt+; first, which copies the hidden rows too.
- Pressing Ctrl+Space inside an Excel Table, where it selects the table column rather than the sheet column — press it twice for the full column.
- Selecting an entire column and then applying conditional formatting or a formula to a million cells, which bloats the file.
Frequently asked questions
How do I select multiple cells in Excel?
Drag for a contiguous block, Shift+click to extend from the active cell, or hold Ctrl while selecting to add separate, non-adjacent ranges to one selection.
How do I select an entire column?
Click any cell in the column and press Ctrl+Space, or click the column letter at the top. Shift+Space does the same for a row.
How do I select all the data below a cell?
Click the cell and press Ctrl+Shift+↓. It extends to the last non-empty cell, stopping at any blank in between.
How do I select only visible cells after filtering?
Select the range and press Alt+; — the Go To Special "Visible cells only" shortcut. Copying then skips the hidden rows.
Other ways people ask this
This is also commonly searched as “how to select a whole row in excel” and “select whole row excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to select a whole row in excel”, “select whole row excel” all point at the one operation explained on this page, which is why they all lead here.