Windows Mac
ShiftSpace ⇧Space

About This Shortcut 

This shortcut selects one or more table rows in a table, when the cursor is in an Excel table. The first time you use it, the entire table row is selected. The second time, the entire worksheet row is selected.

Related videos

Excel Anatomy of an Excel Table

Anatomy of an Excel Table

In this video, we’ll review the key terminology associated with Excel Tables. All Excel tables are composed of rows and columns, and share a number of common elements. First, there’s the table itself, which is a rectangular range of cells with a unique name. You’ll see the table name on the design …
Excel What is an Excel Table

What is an Excel Table

In this video, we’ll introduce the idea of an Excel Table. So, what is an Excel Table? An Excel table is a rectangular range of data that has been defined and named in a particular way. To illustrate, here I have two rectangular ranges of data. Both ranges contain exactly the same data but neither …
Excel Shortcuts for Excel Tables

Shortcuts for Excel Tables

In this video, we’ll look at shortcuts you can use in an Excel Table. Excel Tables are one of Excel’s most powerful features for working with data. To create a table, just select a cell in the data and use Control + T. New tables have filters enabled. To toggle filters, use Ctrl-Shift-L in Windows, …
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

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.