Keyboard Shortcuts (Short)
Sort Options
Alt, A, S
Insert Filter
Alt, A, T
Print Preview
Alt, F, W, V
Increase Decimal
Alt, H, 0
Decrease Decimal
Alt, H, 9
Align Text Options
Alt, H, A
Accounting Number Format
Alt, H, AN
Insert Border
Alt, H, B
Delete Worksheet
Alt, H, D, S
Clear Cell Contents
Alt, H, E, A
Fill Color of Text
Alt, H, FC
Change Font
Alt, H, FF
Change Font Size
Alt, H, FS
Fill Color of Cell
Alt, H, H
Insert Column
Alt, H, I, C
Insert Row
Alt, H, I, R
Comma Format
Alt, H, K
Conditional Formatting
Alt, H, L
Select Number Format
Alt, H, N
Move or Copy Sheet
Alt, H, O, M
Change Tab Name
Alt, H, O, R
Percentage Format
Alt, H, P
AutoSum
Alt, H, U
Paste actual Values
Alt, H, V, A
Paste Formulas
Alt, H, V, F
Paste formatting
Alt, H, V, R
Paste Picture
Alt, H, V, U
Remove tracing arrows
Alt, M, A, A
Trace dependents
Alt, M, D
Trace precedents
Alt, M, P
Evaluate Formula
Alt, M, V
Insert Recommended Charts
Alt, N, R
Inset Pivot Table
Alt, N, V
Insert Textbox
Alt, N, X
Insert illustrations/shapes
Alt, N, ZI
Insert Symbol
Alt, N, ZS
Auto Format
Alt, O, A
Auto fit column width
Alt, O, C, A
Set column width
Alt, O, C, W
Page setup/margins
Alt, P, S, P
Toggle Gridlines
Alt, P, V, G
Review File (comments, stats, protect)
Alt, R
Ungroup rows/columns
Alt, Shift, left arrow
Group rows/columns
Alt, Shift, right arrow
Switch Program
Alt, Tab
Change View (new window, freeze panes, split)
Alt, W
Change Zoom
Alt, W, Q
Navigate Ribbon
Alt, arrow left or right
Display drop down list
Alt, down arrow
Delete cell and get inside
Backspace
Delete selected cells
Ctrl, -
Hide Column
Ctrl, 0
Format Cells Dialog Box
Ctrl, 1
Strike-through Text
Ctrl, 5
Hide Row
Ctrl, 9
Paste Special (all options)
Ctrl, Alt, V
Flash Fill Pattern
Ctrl, E
Find text/value
Ctrl, F
Minimize/Restore ribbon
Ctrl, F1
Name a cell
Ctrl, F3
Replace text/value
Ctrl, H
Move to cell "A1"
Ctrl, Home
New Excel File
Ctrl, N
Switch Worksheets
Ctrl, PgUp/Down
Save File
Ctrl, S
Unhide Column
Ctrl, Shift, 0
Unhide Row
Ctrl, Shift, 9
Select Column
Ctrl, Spacebar
Create Table
Ctrl, T
Redo
Ctrl, Y
Undo
Ctrl, Z
Go to precedent
Ctrl, [
Go to dependent
Ctrl, ]
Go to end of contiguous range
Ctrl, arrow key
Show formulas/values
Ctrl, ~
Delete Cell/Selection
Delete
New Separate Chart
F11
Save as
F12
Edit cells/Highlight dependent cells
F2
Anchor cells
F4
Go-to cell
F5
Spell Check
F7
Recalculate workbooks
F9
Move to "A" column in current row
Home
Insert cells
Shift, Ctrl, +
Display Shortcut menu
Shift, F10
New Worksheet
Shift, F11
Insert Note
Shift, F2
Select Row
Shift, Spacebar
Minimize Program
Windows, D
Open windows File Explorer
Windows, E
Screenshot Tool
Windows, Shift, S
View Clipboard
Windows, V