Excel Shortcuts Cheat Sheet

Functionality

Shortcut

Open help browser

F1

Open keyboard shortcut browser

CMD + /

Functionality

Shortcut

Open a workbook

CTRL+O

Save a workbook

CTRL+S

Close a workbook

CTRL+W

Insert new worksheet

SHIFT+F11

ALT+SHIFT+F1

Functionality

Shortcut

Open the File menu

ALT+F

Open the Home tab

ALT+H

Open the Insert tab

ALT+N

Open the Page Layout tab

ALT+P

Open the Formulas tab

ALT+M

Open the Data tab

ALT+A

Open the Review tab

ALT+R

Open the View tab

ALT+W

Functionality

Shortcut

Move one cell down

ENTER

Down arrow

Move one cell up

SHIFT+ENTER

Up arrow

Move one cell right

TAB

Right arrow

Move one cell left

SHIFT+TAB

Left arrow

Move one screen down

PageDown

Move one screen up

PageUp

Move one screen right

ALT+PageUp

Move one screen left

ALT+PageDown

Move to first row, first column

CTRL+Home

Move to last filled cell

CTRL+End

Functionality

Shortcut

Zoom in

CTRL+ALT+=

Zoom out

CTRL+ALT+-

Functionality

Shortcut

Cut selection

CTRL+X

Copy selection

CTRL+C

Paste selection

CTRL+V

Open the Paste Special dialog

CTRL+ALT+V

Functionality

Shortcut

Undo last action

CTRL+Z

Redo last undone action

CTRL+Y

Functionality

Shortcut

Select the current column

CTRL+Space

Select the current row

SHIFT+Space

Select all cells from the current location downwards

SHIFT+PageDown

Select all cells from the current location upwards

SHIFT+PageUp

Select all cells from the current location rightwards

SHIFT+End

Select all cells from the current location leftward

SHIFT+Home

Select all completed cells

CTRL+A

Functionality

Shortcut

Cancel your input to a cell

Esc

Write a new line within a cell

CTRL+Enter

Go to the end of the line

CTRL+End

Go to the start of the line

CTRL+Home

Insert a function

SHIFT+F3

Display function arguments (when cursor is to right of function name)

CTRL+A

Insert AutoSum formula

ALT+=

Insert hyperlink

CTRL+K

Insert current date

CTRL+;

Insert current time

CTRL+:

Insert a comment on the cell

CTRL+SHIFT+F2

Functionality

Shortcut

Apply bold formatting

CTRL+B

Apply italic formatting

CTRL+I

Apply strikethrough formatting

CTRL+5

Apply general number formatting

CTRL+SHIFT+~

Apply scientific number formatting

CTRL+SHIFT+^

Apply currency format

CTRL+SHIFT+$

Apply percentage format

CTRL+SHIFT+%

Apply date format

CTRL+SHIFT+#

Apply time format

CTRL+SHIFT+@

Toggle hiding/displaying content

CTRL+6

Functionality

Shortcut

Create a chart of the selected data in new worksheet

F11

Create a chart of the selected data in current worksheet

ALT+F11

Functionality

Shortcut

Refresh external data in current worksheet

CTRL+F5

Refresh external data in all worksheets

CTRL+ALT+F5

Run all calculations in all open workbooks

CTRL+ALT+F9