Jump to: Auto Tables, Auto Filter, Pivot Tables
Ctrl+T | Create auto Table from selection |
Ctrl+Space | Select table column |
Shift+Space | Select table row |
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 |
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 |
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy