About This Shortcut
This shortcut selects one or more table rows in a table, when the cursor is in an Excel table. The first time you use it, the entire table row is selected. The second time, the entire worksheet row is selected.
| Windows | Mac |
|---|---|
| ShiftSpace | ⇧Space |
This shortcut selects one or more table rows in a table, when the cursor is in an Excel table. The first time you use it, the entire table row is selected. The second time, the entire worksheet row is selected.
Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.
Get the Lifetime Pass Already have a Pass? Log in to hide ads.
Author
Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles