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.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to set up a running total in a table
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.
Working with table rows and columns
In this video, we'll look at how to work with rows and columns to structure data in an Excel Table.
Shortcuts for selecting cells in Excel
In this video we show you some of Excel's shortcuts for selecting cells.
Shortcuts for selecting cells
In this lesson, we cover shortcuts you can use to select cells.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.