Exceljet

Quick, clean, and to the point

This video comes from our online video training for Excel.

Shortcuts for Excel Tables

Tags 
Summary 
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Video Transcript 

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, and use Command Shift F on a Mac.

A number of shortcuts for selecting cells take advantage of the table structure.

You can select the entire table with Select All — that's control + A on Windows, Command A on a Mac.

The first time you'll get just the table data, and the second time will include the column headers.

To select table row, using Shift + Space.

And a table column, with Control Space.

Both shortcuts work with multiple cells selected.

Insert rows and columns with control shift + in Windows, Control I on a Mac.

Inserted rows go below the selection, and inserted columns go to the left.

Delete rows and columns in a table with Control -.

Tables have very good sport for drag and drop.

I can select one or more rows, then drag directly to a new location.

This is also a good way to duplicate rows in a table. 

Just select the rows you want to copy, and drag with the Control key down in Windows, or Option key on a Mac. 

When a table has filters, you can activate a filter using Alt + down arrow.

In Windows, you get a few more shortcuts once you have an open filter.

You can jump directly to the search by typing E.

You can can tab into the values area and use the up and down arrows to navigate, and then toggle the checkboxes with the spacebar.

When a filter is active in column, you can clear it with Alt + down arrow and C

Finally, you can sort A-Z with S, and sort Z-A with O.

When you have several columns filtered and want to reset all filters at once, just toggle filters off and then on again.

This is really a handy way to make sure that you're looking at all data.

Author 
Dave Bruns

Related shortcuts

CtrlShiftL
F
Alt
CtrlT
T
ShiftSpace
Space
CtrlSpace
Space
CtrlA
A
CtrlShift+
I
CtrlShift+
I
Ctrl-
-
Ctrl-
-
I sincerely want to register my profound gratitude to Dave and Lisa. There are many features so unique about the tutorials in Exceljet: the simplicity, down-to-earth approach and the connection between the instructor and the learner. -John
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course