Shortcuts

In this segment, you will learn a lot about using shortcuts in Microsoft Excel.

Table and Filter Shortcuts

Table and Filter Shortcuts

Command Windows Shortcuts Mac Shortcuts

Insert table

Ctrl +T

Ctrl +T

Insert Table (select style first)

Alt, H, T

 

Insert a row above the current row

Alt, H, I, R

 

Insert a column to the left of the current column

Alt, H, I, C

 

Select Table Body

Ctrl + A

Cmd+A

Select Table row

Shift + Space

Shift + Space

Open Filter Dropdown Menu

Alt + ↓

Alt + ↓

Open Filter Dropdown Menu (from any cell in a Table)

Shift + Alt+ ↓

Shift + Alt+ ↓

Toggle Total Row on/off

Ctrl + Shift + T

Cmd + Shift + T

Clear slicer filter (with slicer selected)

Alt + C

Alt + C