Exceljet

Quick, clean, and to the point

Select table row

Windows shortcut 
ShiftSpace
Mac shortcut 
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.

Related videos

Tip:  Shortcuts for Excel Tables
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Thanks so much for Excel tips. I love your lessons. It is easy to follow and each lesson is not too long. - Won
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course