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.
Select table row
Related videos
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 …
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 …
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, …
Author
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.
Thank you so much! I really like your website it has really helped me teach myself more excel tricks which has helped me with work!
Jaime
Get Training
Quick, clean, and to the point training
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
