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
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with the @ notation, but what about the first row in a column? You might be surprised that you can use INDEX for this.
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
Download 200+ Excel Shortcuts
Comments welcome! Read this before posting a question.
