This is a major rework compared to previous versions. This should be one of the most complete Shortcut References for Excel updated to the latest versions. Most all shortcuts are most likely to work exactly the same on previous versions. Overall if you are a legacy Excel user, try to get used to the Ribbon Shortcuts; they seem cumbersome at first; but worth the effort learning.

1. Navigate Worksheets

Arrow Keys

Navigate by one cell at a time in any direction

Page Down/Page Up

Move one screen down/ up

Alt+Page Down/Page Up

Move one screen right/ left

Tab/Shift+Tab

Move one cell to the right/ to the left in a worksheet

Ctrl+Arrow Keys

Move to the edge of next data region (cells that contains data)

Home

Move to the beginning of row

Ctrl+Home

Move to the beginning of worksheet

Ctrl+End

Move to the last cell with content of worksheet

Ctrl+G

Display the GoTo dialog box

Ctrl+G then type e.g. A50

Go to line 50, Column A

Ctrl+G then type e.g. G1

Go to column G, Line 1

▲ up

2. Select Cells

Basic Selects

Shift+Arrow Keys

Extend selection by one cell

Shift+Page Down/Page Up

Extend selection one screen down/ up

Ctrl+Shift+Arrow Keys

Extend selection to next non-blank cell

Shift+Home

Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent)

Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3*B1:B3)} whichis the sum of A1*B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key

Ctrl+~

Show/ hide all formulas. This will automatically extend all column widths which reverses when presed again

Ctr+'

Duplicate formula from cell above

F3

Paste named range in formula

Ctrl+Backspace

When navigated away while editing formula; jump back to active cell while keeping formula intact.

Trace Dependents and Precedents

Ctrl+[

Select direct precedents

Ctrl+Shift+[

Select all precedents

Ctrl+]

Select direct dependents

Ctrl+Shift+]

Select all dependents

Manual Calculation

F9

Calculate all worksheets in all open workbooks

Shift+F9

Calculate the active worksheet

Ctrl+Alt+F9

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation

Ctrl+Alt+Shift+F9

Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated

▲ up

11. Manage Workbooks

Open and Save Workbooks

Ctrl+O

Open file via standard open dialog box

Alt+F, O

File Open via Excel file manager

Alt+F, O + 1...9

Open recent file (1 thru 9)

Alt+F, O, Y1...Z

Open recent file (10 upwards)

Alt+F, O, K

File Open from OneDrive Link

Ctrl+S

Save File with current file name

F12

Save file as via standard save dialog box

Alt+F, A

File Save as via Excel file manager

Alt+F, A, K

File Save to OneDrive Link

Escape

Exit open/ save menu

Print Workbooks

Ctrl+P

Print. This won't offer offer Key Tips/ Options. To continue with shortcuts, use the new Key Options below.

Unhide selected columns (Ctrl+Shift+0 not working in Excel 2010, 2013, or 2016)

Alt+WS

Split or unsplit Worksheet at current position

▲ up

14. 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

▲ up

15. Column Width and Row Height

It takes only a little bit patience to get used to set row-height and column-width using the pixels instead of the mouse; but only after a short while getting used to the keyboard shortcuts, you won't go back. It can't get any easier to exactly double or triple the row height by working with the values given.

Alt+HO

Home - Format Worksheet

H (in Format Worksheet Menu)

Set row Height

A

Autofit row height

W

Set column Width

I

Autofit column width (Based on current cell; mark column if you want to autfit column based on widest cell)

D

Set Default width (for all columns that haven't been changed yet)

▲ up

16. Navigate Multi-Cell Selections

All these shortcuts assume multipe cells have been selected. Try with at least 2-3 columns and rows.

Tab/Shift+Tab

Move active cell right/ left in selection

Enter/Shift+Enter

Move active cell down/ up in selection

Shift+Backspace

Select only the active cell when multiple cells are selected

Ctrl+Backspace

Show active cell within selection; helps with large selections when active cell is off screen

Ctrl+.

Move clockwise between the four courners of a selection

Ctrl+Alt+Arrow Right/ Arrow Left

Move to the right/ to the left between non-adjacent selections (with multiple ranges selected)

Arrow Keys with active Selection

Cancel Selection

▲ up

17. Comments and Hyperlinks

Ctrl+K

Insert or edit hyperlinK (for complete cell only)

Shift+F10, then R

Remove one or multiple hyperlink(s)

Shift+F10, then 2x O, then Enter

Open hyperlink (In the Excel 2016 Contextmenu, 'O' is double-assigned which require the extra keys)

Shift+F2

Insert/ edit a cell comment

1x Escape when in Comment, then Arrow Keys

Move comment

2x Escape when in Comment

Escape comment editing and return to cell

Ctrl+Shift+O

Select all cells with comments

Shift+F10, then M

Delete single comment (or multipe with multiple comments selected)

▲ up

18. 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++

Insert pivot formula/ calculated field

Alt+F1

Create Pivot Chart in same Worksheet

F1

Create Pivot Chart in new Worksheet

▲ up

19. Excel Auto Tables and Data Forms

Auto Tables

Ctrl+T

Create auto Table from selection

Ctrl+Space

Select table column

Shift+Space

Select table row

Data Forms

Tab/Shift+Tab

Move to the next/ previous field which can be edited

Enter/Shift+Enter

Move to the first field in the next/ previous record

Page Down/Page Up

Move to the same field 10 records forward/ back

Ctrl+Page Down

Move to a new record

Ctrl+Page Up

Move to the first record

Home/End

Move to the beginning/ end of a field

▲ up

20. Group Rows and Columns

Alt+Shift+Arrow Right

Group rows or columns

Alt+Shift+Arrow Left

Ungroup rows or columns

Alt+AH

Data Hide detail

Alt+AJ

Data Show Detail (j is next to h on keyboard that’s probably why they picked 'J' isntead of somthing else)