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 video, we'll look at how to work with rows and columns to structure data in an Excel Table.
In this video we show you some of Excel's shortcuts for selecting cells.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.