Excel Shortcuts for Auto Tables, Auto Filters and Pivot Tables

Jump to: Auto Tables, Auto Filter, Pivot Tables

1. Auto Tables

Ctrl+T

Create auto Table from selection

Ctrl+Space

Select table column

Shift+Space

Select table row

2. Auto Filter

Ctrl+Shift+L

Turn Autofilter on or off. Select table as necessary but many times Excel figures out what you want.

Alt+Arrow Down

On the field with column head, display the AutoFilter list for the current column. Press Escape to cancel

Arrow Down/Arrow Up and Sace

Select the next/ previous item in the AutoFilter list

Alt+Arrow Up

Close the AutoFilter list for the current column

Home/End

Select the first item/ last item in the AutoFilter list

3. Pivot Tables

Creating Pivot Tables with Shortcuts only seems to be nearly impossible; managing existing tables is doable.

Alt+NV

Insert PivotTable after selecting data range. Follow up with Alt+E for existing worksheet if desired, Tab, and type the cell reference where it should go (e.g. C1)

F10+R

Refresh PivotTable

Ctrl+-

Hide selected item

Alt+Arrow Down in header

Unhide item(s) by opening header drop-down and using Arrow Keys and Space to unhide item

Type over any field with the value hidden

Unhide item(s) (assume you have two fields 'color', and 'size' and you hid 'color'. Go into 'size' field and type 'color' - this will unhide the 'color' field

Type over any field with another field in same table

Flip current field value with the value typed

Ctrl+Shift+*

Select the entire PivotTable report

Alt+Shift+Arrow Right

Group selected PivotTable items

Alt+Shift+Arrow Left

Ungroup selected PivotTable items when on group header

Alt+JTX

Expand all fields

Alt+JTP

Collapse all fields

Ctrl+Shift+plus

Insert pivot formula/ calculated field

Alt+F1

Create Pivot Chart in same Worksheet

F1

Create Pivot Chart in new Worksheet

icon

Microsoft Excel Shortcuts

Advertising for Consideration:

Ads for Consideration:

Related:

Please kindly review and accept Terms of Use and Cookie & Policy Policy