Dart
Dart
HTML Canvas
HTML Canvas
Redis
Redis
Bash
Bash
JavaScript
JavaScript

Excel Shortcuts Cheat Sheet

With the Excel shortcuts cheat sheet, you can improve your Excel skills.

Keyboard Shortcuts
Shortcuts
Excel

Getting Help

FunctionalityShortcut
Open help browserF1
Open keyboard shortcut browserCMD + /

Manipulating Workbooks

FunctionalityShortcut
Open a workbookCTRL+O
Save a workbookCTRL+S
Close a workbookCTRL+W
Insert new worksheet

SHIFT+F11

ALT+SHIFT+F1

Access Ribbon Tabs

FunctionalityShortcut
Open the File menuALT+F
Open the Home tabALT+H
Open the Insert tabALT+N
Open the Page Layout tabALT+P
Open the Formulas tabALT+M
Open the Data tabALT+A
Open the Review tabALT+R
Open the View tabALT+W

Zooming

FunctionalityShortcut
Zoom inCTRL+ALT+=
Zoom outCTRL+ALT+-

Editing

FunctionalityShortcut
Cut selectionCTRL+X
Copy selectionCTRL+C
Paste selectionCTRL+V
Open the Paste Special dialogCTRL+ALT+V

Undo & Redo

FunctionalityShortcut
Undo last actionCTRL+Z
Redo last undone actionCTRL+Y

Selecting Cells

FunctionalityShortcut
Select the current columnCTRL+Space
Select the current rowSHIFT+Space
Select all cells from the current location downwardsSHIFT+PageDown
Select all cells from the current location upwardsSHIFT+PageUp
Select all cells from the current location rightwardsSHIFT+End
Select all cells from the current location leftwardSHIFT+Home
Select all completed cellsCTRL+A

Cell Entry

FunctionalityShortcut
Cancel your input to a cellEsc
Write a new line within a cellCTRL+Enter
Go to the end of the lineCTRL+End
Go to the start of the lineCTRL+Home
Insert a functionSHIFT+F3
Display function arguments (when cursor is to right of function name)CTRL+A
Insert AutoSum formulaALT+=
Insert hyperlinkCTRL+K
Insert current dateCTRL+;
Insert current timeCTRL+:
Insert a comment on the cellCTRL+SHIFT+F2

Text Formatting

FunctionalityShortcut
Apply bold formattingCTRL+B
Apply italic formattingCTRL+I
Apply strikethrough formattingCTRL+5
Apply general number formattingCTRL+SHIFT+~
Apply scientific number formattingCTRL+SHIFT+^
Apply currency formatCTRL+SHIFT+$
Apply percentage formatCTRL+SHIFT+%
Apply date formatCTRL+SHIFT+#
Apply time formatCTRL+SHIFT+@
Toggle hiding/displaying contentCTRL+6

Charts

FunctionalityShortcut
Create a chart of the selected data in new worksheetF11
Create a chart of the selected data in current worksheetALT+F11

Refreshing Data

FunctionalityShortcut
Refresh external data in current worksheetCTRL+F5
Refresh external data in all worksheetsCTRL+ALT+F5
Run all calculations in all open workbooksCTRL+ALT+F9