StickyWords
← All word lists

Excel keyboard shortcuts for Windows

The keys that save a trip to the mouse, as Excel sets them on Windows: Ctrl+; for today's date, Alt+= for AutoSum, Ctrl+Shift+L for filters.

A spreadsheet with a sum cell above a keyboard with the Alt and = keys lit up in blue
Action Shortcut
New workbook Ctrl+N
Open a workbook Ctrl+O
Save As F12
Print Ctrl+P
Close the workbook Ctrl+W
Redo / repeat last action Ctrl+Y
Find and replace Ctrl+H
Go To a cell or range Ctrl+G / F5
Show / hide the ribbon Ctrl+F1
Check spelling F7
Go to cell A1 Ctrl+Home
Go to the last used cell Ctrl+End
Jump to the edge of the data Ctrl+Arrow key
Next worksheet Ctrl+PgDn
Previous worksheet Ctrl+PgUp
Insert a new worksheet Shift+F11
Select the entire column Ctrl+Space
Select the entire row Shift+Space
Select the region / all Ctrl+A
Extend selection to data edge Ctrl+Shift+Arrow key
Select visible cells only Alt+;
Edit the active cell F2
New line inside a cell Alt+Enter
Enter into all selected cells Ctrl+Enter
Fill down Ctrl+D
Fill right Ctrl+R
Paste Special Ctrl+Alt+V
Paste values (Microsoft 365) Ctrl+Shift+V
Copy formula from cell above Ctrl+'
Insert today's date Ctrl+;
Insert the current time Ctrl+Shift+:
Insert cells / rows / columns Ctrl+Shift+Plus
Delete cells / rows / columns Ctrl+Minus
Flash Fill Ctrl+E
Add or edit a note Shift+F2
Insert a hyperlink Ctrl+K
Format Cells dialog Ctrl+1
Strikethrough Ctrl+5
Currency format Ctrl+Shift+$
Percentage format Ctrl+Shift+%
Number format (2 decimals) Ctrl+Shift+!
Date format Ctrl+Shift+#
General format Ctrl+Shift+~
Add an outline border Ctrl+Shift+&
Remove borders Ctrl+Shift+_
AutoFit column width Alt+H, O, I
Hide selected rows Ctrl+9
Hide selected columns Ctrl+0
Unhide rows Ctrl+Shift+9
Group rows or columns Alt+Shift+Right
Ungroup rows or columns Alt+Shift+Left
AutoSum Alt+=
Insert Function dialog Shift+F3
Cycle absolute / relative refs F4 (while editing)
Show formulas Ctrl+`
Recalculate all workbooks F9
Name Manager Ctrl+F3
Expand the formula bar Ctrl+Shift+U
Turn filters on / off Ctrl+Shift+L
Open a filter drop-down Alt+Down
Create a table Ctrl+T
Insert a chart on this sheet Alt+F1
Insert a chart on a new sheet F11
Run or view macros Alt+F8
Open the VBA editor Alt+F11

Keep this list on your screen.

StickyWords shows it one pair at a time in the corner of your screen while you work. The CSV opens in any spreadsheet if you would rather edit it first.