Excel keyboard shortcuts (Windows and Mac)

Open workbook

Save as

Close current workbook

Expand or collapse ribbon

Move to next ribbon control

Confirm change

Move one control down

Move one control left

Undo last change

Toggle Autofilter

Move one cell down

Move one cell left

Move one screen down

Move one screen left

Move to bottom edge of data region

Move to left edge of data region

Show active cell

Move one cell down

Move one cell left

Select entire column

Select entire worksheet

Expand selection

Move left between selections

Select active cell only

Move active cell down in selection

Move active cell right in selection

Extend selection by one cell up

Extend selection by one cell right

Extend the selection to the last cell up

Extend the selection to the last cell right

Extend selection up one screen

Extend selection to beginning of row

Extend selection to last cell in data range

Select region around active cell

Create names from selection

Select all cells with comments

Select row differences

Select direct precedents

Select direct dependents

Select visible cells only

Cut selected data

Open Paste special window

Copy and paste

Copy and insert

Duplicate worksheet

Copy cell to the left and paste in active cell

Copy above cell and edit as value in active cell

Edit active cell

Select one character right

Move one word right

Select one word right

Select to beginning of cell

Delete after cursor

Delete character to the right

Confirm entry and move down

Confirm entry and move right

Confirm entry and stay in the cell

Insert hyperlink

Flash fill

Apply currency format

Apply scientific format

Open Find window

Find next match

Create chart in current worksheet

Insert current date

Apply date format

Move to next control

Move to next tab

Apply changes

Close without saving

Open Insert Function window

Toggle Value / Formula display

Confirm entry as array formula

Calculate current worksheet

Expand the formula bar

Paste name into formula

Force calculate all worksheets

Hide or show outline symbols

Insert rows

Open Delete window

Delete columns

Hide rows

Unhide rows

Ungroup rows or columns

Open Ungroup window

Select table row

Select table

Open Format Cells window (font tab)

Make text bold

Underline text

Apply outside borders

Insert new worksheet

Go to previous worksheet

Move to previous pane

Move to previous workbook

Maximize current workbook

Select adjacent worksheets

Insert macro sheet

Check table field

Ungroup pivot table items

Create pivot chart on same worksheet

Open Spelling window

Open Macro window

Snap to grid

Open Style window

Display contextual menu (fn)