Excel Keyboard Shortcuts
Delete row / column
CTRL + -
Format Cells menu
CTRL + 1
Select All
CTRL + A
Refresh All Pivot Tables
CTRL + ALT + F5
Bold text
CTRL + B
Copy cells
CTRL + C
Copy down
CTRL + D
Find
CTRL + F
Name a cell / range
CTRL + F3
Close file
CTRL + F4
Replace
CTRL + H
Go to cell A1 on sheet
CTRL + HOME
Italics
CTRL + I
Add entry to slicer selection
CTRL + Mouse click
New file
CTRL + N
Open File
CTRL + O
Move to next worksheet
CTRL + PgUp / PgDn
Copy right
CTRL + R
Save file
CTRL + S
Apply Number format
CTRL + SHIFT + !
Apply Date format
CTRL + SHIFT + #
Apply Currency format
CTRL + SHIFT + $
Apply Percentage format
CTRL + SHIFT + %
Add border
CTRL + SHIFT + &
Delete borders
CTRL + SHIFT + -
Apply Time format
CTRL + SHIFT + @
Apply General format
CTRL + SHIFT + ~
Select cells to end of boundary
CTRL + SHIFT + →
Select one word in cell
CTRL + SHIFT + →
Select column
CTRL + Spacebar
Toggle Workbooks
CTRL + TAB
Underline
CTRL + U
Paste cells
CTRL + V
Cut cells
CTRL + X
Redo
CTRL + Y
Undo
CTRL + Z
Show formulas
CTRL + ~
Go to end of boundary
CTRL + →
Skip word in cell
CTRL + →
Format PT cells
RMBK*, F
Open Grouping dialog box
RMBK*, G
Sort PT cells
RMBK*, S
Remove a filter from PT
RMBK*, T, C
Create a filter rule for PT
RMBK*, T, S
New worksheet
SHIFT + F11
Add / edit comment
SHIFT + F2
Select multiple areas
SHIFT + F8
Select all text in cell
SHIFT + HOME/END
Select row
SHIFT + Spacebar
Select multiple cells
SHIFT + →
Autofit columns
ALT + O, C, A
Change column width
ALT + O, C, W
Rename worksheet
ALT + O, H, R
Show / Hide all comments
ALT + R, A
Remove comment
ALT + R, D
Open Zoom dialog box
ALT + V, Z
Freeze / Unfreeze panes
ALT + W, F, F
Group rows / columns
ALT + A, G, G
Collapse entire field
ALT + A, H
Hide grouped cells
ALT + A, H
Expand entire field
ALT + A, J
Show grouped cells
ALT + A, J
Sort Data Ascending
ALT + A, S, A
Sort Data Descending
ALT + A, S, D
Sort Data
ALT + A, S, S
Ungroup rows / columns
ALT + A, U, U
Clear slicer selection
ALT + C
Paste formulas
ALT + E, S, F
Paste formats
ALT + E, S, T
Paste values
ALT + E, S, V
Close Excel
ALT + F4
Add a decimal place
ALT + H, 0
Remove a decimal place
ALT + H, 9
Border menu
ALT + H, B
Change text color
ALT + H, F, C
Change text size
ALT + H, F, S
Move / Copy worksheet
ALT + H, O, M
Format as Table
ALT + H, T
Insert new column
ALT + I, C
Insert new row
ALT + I, R
Show values as
ALT + J, T, A
Summarize values by
ALT + J, T, D
Insert slicer
ALT + J, T, S, L
Insert banded rows
ALT + J, Y, R
Change PT style
ALT + J, Y, S
Remove all traces
ALT + M, A, A
Trace dependents
ALT + M, D
Trace precedents
ALT + M, P
Create Pivot Chart
ALT + N, C
Create Pivot Table
ALT + N, V
Delete cell
Delete
Go to last character in cell
END
Leave cell without changes
Escape
Save As
F12**
Edit cell
F2**
Anchor a cell / range
F4**
Repeat last action
F4**
Jump to cell
F5**
Go to first cell in row
HOME
Go to first character in cell
HOME
