Work & productivity / QUICK REFERENCE
Excel keyboard shortcuts
Move, select, edit and format quickly using the Windows desktop defaults.
Edit cells and formulas
- Edit active cell
- F2
Enters cell editing when permitted. [1]
- Cancel current entry
- Esc
Abandons the current edit or action. [1]
- Line break inside cell
- Alt+Enter
Inserts a newline while editing text. [1]
- Fill down
- Ctrl+D
Copies the top cell of the selection downward. [1]
- Fill right
- Ctrl+R
Copies the leftmost cell across the selection. [1]
- Insert current date
- Ctrl+;
Inserts a fixed date value. [1]
- Insert current time
- Ctrl+Shift+;
Inserts a fixed time value. [1]
- Cycle reference style
- F4 while editing a reference
Cycles relative/absolute reference variants. [1]
- Toggle formula display
- Ctrl+`
Switches between formula text and results. [1]
- AutoSum
- Alt+=
Suggests a sum range; inspect it before confirming. [1]
Format and organize
- Format Cells dialog
- Ctrl+1
Opens detailed formatting options. [1]
- Bold
- Ctrl+B
Toggles bold formatting. [1]
- Italic
- Ctrl+I
Toggles italic formatting. [1]
- Underline
- Ctrl+U
Toggles underline formatting. [1]
- General number format
- Ctrl+Shift+~
Uses General formatting. [1]
- Percentage format
- Ctrl+Shift+%
Changes display, not the underlying scale of the value. [1]
- Create a table
- Ctrl+T
Confirm the range and header selection. [1]
- Toggle filter controls
- Ctrl+Shift+L
Adds or removes filter arrows. [1]
Workbook actions
- Save workbook
- Ctrl+S
Writes changes to the current file. [1]
- Print settings
- Ctrl+P
Check scaling and selected sheets before printing. [1]
- Find
- Ctrl+F
Searches within the configured scope. [1]
- Replace
- Ctrl+H
Review the scope before replacing cells. [1]
- Undo
- Ctrl+Z
Not every operation can be undone. [1]
- Go To dialog
- F5
Jumps to a reference or named range. [1]
Reserved placement, separate from reference controls. No ad network is active.
No matching entry. Try a shorter word or clear the search to see the complete sheet.
Sources
cheatsheetatlas.com/sheets/excel-shortcuts/ · Updated 2026-10-19 · Excel for Windows · keyboard defaults