To select all rows below a certain point in Google Sheets, click the row number where the selection should start, then press Ctrl + Shift + Down Arrow (Command + Shift + Down Arrow on a Mac). This selects that row and every row below it to the end of the sheet. To stop at a specific row instead, click the first row number, hold Shift, and click the last row number.
Once they’re selected, you can delete, hide, or format all those rows together.
Quick Answer
Click the starting row number, then press Ctrl + Shift + ↓.
Select From a Row to the End of the Sheet
- Click the row number on the left where you want to start (for example, 6).
- Press Ctrl + Shift + Down Arrow.
- If the sheet has data below, the selection may stop at the end of the data. Press the shortcut again to extend it to the last row.
Other Ways to Select Rows Below
| Goal | How |
|---|---|
| A range of rows | Click the first row number, hold Shift, click the last |
| Rows below, only within the data | Click a cell, press Ctrl + Shift + Down Arrow |
| Rows that aren’t next to each other | Hold Ctrl (Command) and click each row number |
| An exact range | Type it in the Name box (left of the formula bar), for example A6:Z1000, and press Enter |
| Extend by one row at a time | Hold Shift and press Down Arrow |
Delete All Rows Below a Point
- Select the rows using the steps above.
- Right-click any selected row number.
- Choose Delete rows X–Y.
Deleting unused rows below your data makes large sheets load faster. To clear the content but keep the rows, press Delete instead.
Hide Rows Below a Point
Select the rows, right-click a row number, and choose Hide rows. Arrows appear where rows are hidden; click them to show the rows again.
Troubleshooting
- The shortcut selects only a few rows: It stops at blank cells or the end of data. Press it again, or start from the row number instead of a cell.
- On a Mac, the shortcut switches spaces: Use Command + Shift + Down Arrow, not Ctrl.
Need to add rows instead? See how to insert multiple rows in Google Sheets, or number your rows automatically.
Related: hide rows in Google Sheets.
Frequently Asked Questions
How do I select everything below a certain cell?
Click the cell and press Ctrl + Shift + Down Arrow. Add Ctrl + Shift + Right Arrow to extend across columns too.
Can I do this in the mobile app?
Tap a row number, then drag the blue handle down. There are no keyboard shortcuts on touch screens.
Summary
- Click the starting row number.
- Press Ctrl + Shift + Down Arrow.
- Right-click to delete or hide the selected rows.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.