EXCEL Shortcuts

 General

Open help F1

Undo last action Ctrl + Z

Redo last action Ctrl + Y

Copy selection Ctrl + C

Repeat last action F4

Cut selection Ctrl + X

Paste content from clipboard Ctrl + V

Display the Paste Special dialog box Ctrl + Alt + V

Find previous match (after initial Find) Ctrl + Shift + F4

Find next match (after initial Find) Shift + F4

Insert embedded chart Alt + F1

Insert embedded chart Alt + F1

Toggle Autofilter Ctrl + Shift + L

Activate Filter Alt + ↓

Create table Ctrl + T 

Select table row Shift + Space

Select table column Ctrl + Space 

Select table (when active cell is in table) Ctrl + A

Clear slicer filter  Alt + C

Run Spellcheck F7

Open Thesaurus Shift + F7

Open Macro dialog box Alt + F8

Open VBA Editor Alt + F11

Duplicate object Ctrl + D

Snap to grid (whilst dragging) Alt

Hide or show objects Ctrl + 6

Open Modify Cell Style dialog box Alt + ' 

Show right-click menu Shift + F10

Display control menu Alt Space

Worksheet 

Insert new worksheet Shift + F11 

Go to next worksheet Ctrl + PgDn 

Go to previous worksheet Ctrl + PgUp 

Rename current worksheet Alt + O , H R 

Delete current worksheet Alt + E , L 

Move current worksheet Alt + E , M 

Move between the worksheet, Ribbon, 

task pane and zoom controls in a worksheet 

that has been split F6 OR Shift + F6

Select adjacent worksheets Ctrl + Shift + PgUp/PgDn 

Select non-adjacent worksheets Ctrl + Click Toggle scroll lock ScrLk 

Toggle full screen Ctrl + Shift + F1

Print Ctrl + P 

Open print preview window Ctrl + F2 

Set print area Alt + P , R S 

Clear print area Alt + P , R C 

Zoom in Ctrl + Mouse Wheel Up 

Zoom out Ctrl + Mouse Wheel Down 

Protect sheet Alt + R , P S

Create new workbook Ctrl + N 

Open workbook Ctrl + O 

Save workbook Ctrl + S 

Save as F12 

Go to next workbook Ctrl + Tab 

Go to previous workbook Ctrl + Shift + Tab 

Minimize current workbook window Ctrl + F9 

Maximize current workbook window Ctrl + F10 

Protect workbook Alt + R , P W 

Close current workbook Ctrl + F4 

Close Excel Alt + F4

Ribbon

Expand or collapse ribbon Ctrl + F1 

Activate access keys Alt 

Move through Ribbon tabs and groups → ← ↑ ↓ 

Activate or open selected control Space OR Enter 

Confirm control change enter

Get help on selected control f1