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.

Shortcuts for selecting cells

In this lesson, we cover shortcuts you can use to select cells.

Shortcuts for selecting cells in Excel

In this video we show you some of Excel's shortcuts for selecting cells.

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.

Download 200+ Excel Shortcuts

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

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I've used your site for years but just thought that perhaps you might welcome hearing how I return to yours time and time again as my first choice when I'm either learning a new Excel function, or refreshing my memory. I continue to be impressed by every aspect of your site and how user-friendly it is -- from the size and choice of font, to the page organization, to the speed and clarity of the videos, and of course to the organization and clarity of the explanations. -Anna

Select entire row

Related videos

Download 200+ Excel Shortcuts

Excel video training