Exceljet

Quick, clean, and to the point

Select entire row

Windows shortcut 
ShiftSpace
Mac shortcut 
Space

This shortcut will select the entire row of the current selection. If the current selection spans multiple rows, all rows that intersect the selection will be selected.

Related videos

The videos below demonstrate this shortcut.
Setting up a running total in an Excel table is a bit tricky because it's not obvious how to use structured references. This video explores some options.
In this lesson, we cover shortcuts you can use to select cells.
In this video, we show you how some of Excel's shortcuts for selecting cells.
In this video, we'll look at how to work with rows and columns to structure data in an Excel Table.