Ctrl = Control key on Windows/Linux. On Mac, replace Ctrl with ⌘ (Command) and Alt with ⌥ (Option). This guide shows Windows shortcuts; Mac equivalents are noted where they differ.
Universal Shortcuts (Work Everywhere)
These shortcuts work in Word, Excel, PowerPoint, and most other applications:
Action
Windows
Mac
Copy
Ctrl+C
⌘C
Cut
Ctrl+X
⌘X
Paste
Ctrl+V
⌘V
Undo
Ctrl+Z
⌘Z
Redo
Ctrl+Y
⌘Y
Save
Ctrl+S
⌘S
Find
Ctrl+F
⌘F
Find & Replace
Ctrl+H
⌘+Shift+H
Select All
Ctrl+A
⌘A
Print
Ctrl+P
⌘P
Bold
Ctrl+B
⌘B
Italic
Ctrl+I
⌘I
Underline
Ctrl+U
⌘U
Microsoft Word Shortcuts
Action
Windows
New document
Ctrl+N
Open document
Ctrl+O
Align left / centre / right
Ctrl+L / Ctrl+E / Ctrl+R
Justify paragraph
Ctrl+J
Increase / decrease font size
Ctrl+Shift+> / Ctrl+Shift+<
Insert hyperlink
Ctrl+K
Insert page break
Ctrl+Enter
Format painter (copy formatting)
Ctrl+Shift+C to copy, Ctrl+Shift+V to paste
Word count
Ctrl+Shift+G
Move paragraph up / down
Alt+Shift+↑ / Alt+Shift+↓
Microsoft Excel Shortcuts
Action
Windows
AutoSum selected cells
Alt+=
Edit active cell
F2
Fill down (copy formula down)
Ctrl+D
Fill right (copy formula right)
Ctrl+R
Insert current date / time
Ctrl+; / Ctrl+Shift+;
Select entire column / row
Ctrl+Space / Shift+Space
Jump to edge of data region
Ctrl+Arrow
Select to edge of data
Ctrl+Shift+Arrow
Insert new row / column
Ctrl+Shift++
Delete row / column
Ctrl+-
Format as currency
Ctrl+Shift+$
Format as percentage
Ctrl+Shift+%
Toggle absolute/relative references
F4 (while editing formula)
Create table from data
Ctrl+T
Insert chart (quick)
Alt+F1
Three Excel Formulas That Will Change Your Life
=XLOOKUP(lookup_value, lookup_array, return_array) — The modern replacement for VLOOKUP. Easier to write, more powerful. Find a value in one column and return the matching value from another.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...) — Combine text from multiple cells with a separator. Much cleaner than concatenating with &.
=IFS(condition1, value1, condition2, value2, ...) — Multiple IF statements in one clean formula. No more nesting IF inside IF inside IF.
