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. Treat “select multiple rows in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected rows shows up while it is still harmless. 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 turns a text operation that turns messy entries into clean, usable data into a method you can reuse, explain, and defend when the workbook leaves your screen.
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. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “select multiple rows in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.
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
On the way here you may have searched this as “how to select different rows in excel”, “select multiple rows excel” and “randomly select rows in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to select different rows in excel”, “select multiple rows excel”, “randomly select rows in excel” all point at the one operation explained on this page, which is why they all lead here.