Press what you remember

Move the selection one cell up

Move the selection one cell down

Move the selection one cell left

Move the selection one cell right

Jump to the top edge of the current block of data

From a blank cell it jumps to the next cell that holds something

Jump to the bottom edge of the current block of data

Jump to the left edge of the current block of data

Jump to the right edge of the current block of data

Go to cell A1 of the worksheet

With frozen panes it stops at the first unfrozen cell

Go to the last cell of the used range

The used range can stretch past the visible data until the file is saved again

Move to the first column of the current row

Move one screen down

Move one screen up

Move one screen to the right

Move one screen to the left

Go to the next worksheet

Go to the previous worksheet

Open the Go To dialog

Type a cell reference or pick a named range to jump straight to it

Open the Go To dialog

The same dialog as Ctrl+G

Open Find

Open Replace

Repeat the last search and move to the next match

Repeat the last search and move to the previous match

Turn on End mode, then jump to the next edge of data to the right

End mode switches itself off once the jump is done

Turn on End mode, then jump to the next edge of data below

Turn on End mode, then move to the last cell of the used range

Scroll the window back to the active cell

Move between the worksheet, the ribbon, an open pane, and the status bar

Move the other way between the worksheet, the ribbon, and the status bar

Select the block of data around the active cell, then the whole worksheet

Press it again to widen the selection. While a function name is being typed it opens the Function Arguments dialog instead

Select the whole worksheet

Inside a table it selects the table data first, then the whole worksheet

Select the whole row

Select the whole column

Inside a table it selects the table column first

Extend the selection one cell up

Extend the selection one cell down

Extend the selection one cell left

Extend the selection one cell right

Extend the selection to the top edge of the block of data

Extend the selection to the bottom edge of the block of data

Extend the selection to the left edge of the block of data

Extend the selection to the right edge of the block of data

Extend the selection to the first column of the row

Extend the selection back to cell A1

Extend the selection to the last cell of the used range

Extend the selection one screen down

Extend the selection one screen up

Select the block of data around the active cell

Published as Ctrl+Shift+*. Inside a PivotTable it selects the whole report

Select only the visible cells in the current selection

Copying after this leaves hidden and filtered rows out

Turn extend mode on or off so the arrow keys grow the selection

Turn on add mode to append another range to the selection

Select the whole array the active cell belongs to

Select the cells in each selected row that differ from the active row

Select the cells in each selected column that differ from the active column

Published as Ctrl+Shift+|

Move clockwise to the next corner of the selected range

Select the cells that carry a note or a comment

Add the next worksheet to the selected sheets

Add the previous worksheet to the selected sheets

Open Go To, then Special, to select cells by type such as blanks, formulas, or constants

Confirm the entry and move down

The direction is set in the Excel options, and inside a selection it stays within the selection

Confirm the entry and move up

Confirm the entry and move one cell right

While a formula is being typed it accepts the highlighted suggestion instead

Confirm the entry and move one cell left

Start a new line inside the same cell

Put what was typed into each cell of the selection

Cancel the entry and restore the previous contents

Edit the active cell in place

The cursor lands at the end of the existing contents

Fill the selection down from the top row

Fill the selection right from the first column

Enter today's date as a fixed value

The value does not update later, unlike the TODAY function

Enter the current time as a fixed value

Copy the formula from the cell above into the active cell

References are copied as written, without the usual row shift

Copy the value from the cell above into the active cell

Published as Ctrl+Shift+"

Open the drop-down list for the active cell

Offers the entries already used in the column, a validation list, or a filter menu on a header cell

Fill the column by following the example already typed

Copy the selection

Cut the selection

Paste the clipboard

Open the Paste Special dialog

Undo the last action

Redo the action that was undone

Repeat the last action

While a formula is being edited it cycles the reference under the cursor between relative, absolute, and mixed instead

Open the Insert dialog for cells, rows, or columns

Published as Ctrl+Plus. With a whole row or column selected it inserts one straight away

Open the Delete dialog for cells, rows, or columns

Clear the contents of the selection and leave the formatting

Clear the active cell and start typing

While editing it deletes the character to the left of the cursor

Delete from the cursor to the end of the line while editing

Insert or edit a hyperlink

Expand or collapse the formula bar

Insert rows above the selection

Insert columns to the left of the selection

Delete the selected rows

Delete the selected columns

Paste values only

Paste formulas without the source formatting

Paste the copied range with rows and columns swapped

Open the Paste Special dialog from the ribbon

Clear the contents and the formatting of the selection

Clear the contents of the selection from the ribbon

Open the Format Cells dialog

Turn bold on or off

Turn italic on or off

Turn underline on or off

Turn strikethrough on or off

Turn bold on or off

The same result as Ctrl+B

Turn italic on or off

The same result as Ctrl+I

Turn underline on or off

The same result as Ctrl+U

Open Format Cells with the Font tab in front

Open Format Cells at the font settings

Apply the General number format

Published as Ctrl+Shift+~

Apply the number format with two decimals and a thousands separator

Published as Ctrl+Shift+!

Apply the time format with hours and minutes

Published as Ctrl+Shift+@

Apply the date format with day, month, and year

Published as Ctrl+Shift+#

Apply the currency format with two decimals

Published as Ctrl+Shift+$

Apply the percentage format with no decimals

Published as Ctrl+Shift+%

Apply the scientific format with two decimals

Published as Ctrl+Shift+^

Put an outline border around the selection

Published as Ctrl+Shift+&

Remove the borders from the selection

Published as Ctrl+Shift+_

Hide the selected rows

Unhide the hidden rows inside the selection

Hide the selected columns

Unhide the hidden columns inside the selection

Some Windows keyboard layout settings claim this combination, in which case use the ribbon route Alt, H, O, U, L

Open the Style dialog

Fit the column width to the widest entry

Fit the row height to the tallest entry

Set an exact column width

Set an exact row height

Merge the selected cells and centre the contents

Split merged cells back apart

Turn text wrapping on or off

Show one more decimal place

Show one fewer decimal place

Align the contents to the left

Centre the contents horizontally

Align the contents to the right

Align the contents to the top of the cell

Centre the contents vertically

Align the contents to the bottom of the cell

Open the borders menu

Open the fill colour picker

Open the font colour picker

Pick up the formatting of the selection to brush onto another range

Open the conditional formatting menu

Clear the formatting and keep the contents

Open the number format list on the Home tab

Start a formula in the active cell

Insert a SUM formula for the range above or to the left

Confirm the formula as a legacy array formula

Builds that support dynamic arrays spill without it

Show the formulas in the cells instead of their results

Open the Insert Function dialog

Insert the argument names of the function just typed

Paste a defined name into the formula

Available once the workbook has at least one defined name

Open the Name Manager

Create defined names from the labels in the selection

Calculate the formulas that changed in the open workbooks

While editing a formula it replaces the selected part with its current value

Calculate the active worksheet only

Recalculate the open workbooks, changed or not

Rebuild the dependency tree and recalculate the open workbooks

Select the cells the formula in the active cell refers to

Select the formulas that refer to the active cell

Select the cells the active formula depends on, directly and indirectly

Published as Ctrl+Shift+{

Select the formulas that depend on the active cell, directly and indirectly

Published as Ctrl+Shift+}

Define a name for the selection

Draw arrows to the cells the active formula refers to

Draw arrows to the formulas that refer to the active cell

Remove the tracing arrows from the worksheet

Step through the formula in the Evaluate Formula dialog

Open the calculation options, where automatic and manual are set

Turn the selected range into an Excel table

Open the same Create Table dialog as Ctrl+T

Add or remove the filter row

Add or remove the filter row from the Data tab

Clear the filters on the current sheet

Open the Sort dialog for multi-level sorting

Sort the current column in ascending order

Sort the current column in descending order

Open Remove Duplicates for the selected range

Open the Text to Columns wizard

Open the Data Validation dialog

Refresh the workbook's queries and connections

Open the Advanced Filter dialog

Open the Subtotal dialog for a sorted list

Group the selected rows or columns into an outline

Ungroup the selected rows or columns

Show or hide the outline symbols beside a grouped range

Add or remove the filter row through the older menu route

Start inserting a PivotTable from the Insert tab

Recent builds add one more step for the data source

Open the older PivotTable and PivotChart Wizard

Useful for consolidating several ranges into one report

Refresh the PivotTable under the cursor

Refresh the data connections and PivotTables in the workbook

Group the selected PivotTable items

Ungroup the selected PivotTable items

Open the PivotTable Analyze tab

The contextual tabs only appear while the cursor sits inside a PivotTable

Create a new workbook

Open an existing workbook

Save the workbook

Open Save As to write a new file

Open the print settings

Open the print preview

Close the active workbook

Close the active workbook window

Close Excel

Move to the next open workbook window

Move to the previous open workbook window

Move to the next workbook window

Move to the previous workbook window

Minimise the workbook window

Maximise or restore the workbook window

Restore the size of the workbook window

Move the workbook window with the arrow keys

Available while the window is not maximised

Resize the workbook window with the arrow keys

Insert a new worksheet

Freeze the rows above and the columns left of the active cell

Freeze the top row

Freeze the first column

Split the window into scrollable panes

Open the Zoom dialog

Open a second window onto the same workbook

Open the Arrange Windows dialog to tile or cascade the open workbooks

Switch to the normal view

Switch to the page break preview

Rename the active worksheet

Open Move or Copy for the active worksheet

Set the colour of the worksheet tab

Delete the active worksheet

Deleting a sheet cannot be undone

Insert a worksheet from the ribbon

Hide the active worksheet

Show the ribbon key tips, then type the letters they display

The multi-step routes here, the ones whose first step is Alt on its own, are read from those key tips. A chord such as Alt+Enter is not one of them

Show the ribbon key tips

The same as pressing Alt

Open the Home tab

Open the Insert tab

Open the Page Layout tab

Open the Formulas tab

Open the Data tab

Open the Review tab

Open the View tab

Open the File menu

Jump to the search box that runs ribbon commands by name

Open the New page of the File menu

Open the Open page of the File menu

Save the workbook from the File menu

Open the Save As page of the File menu

Open the Print page of the File menu

Open the Info page of the File menu

Open the Export page of the File menu

Close the workbook from the File menu

Open the Excel options

Collapse or expand the ribbon

Run the first command on the Quick Access Toolbar

The number matches the position of the command on that toolbar

Run the second command on the Quick Access Toolbar

Open Help

Open the context menu for the selection

The same menu a right click opens

Check the spelling on the worksheet

Open the thesaurus for the active cell

Open the Macro dialog

Open the Visual Basic editor

Create a chart from the selected data on the current worksheet

Create a chart from the selected data on a new chart sheet

Show or hide the objects that sit over the grid

Add or edit a note on the active cell

Open the Protect Sheet dialog

Open the Protect Workbook dialog