Work & productivity / QUICK REFERENCE

Excel keyboard shortcuts

Move, select, edit and format quickly using the Windows desktop defaults.

34 entries

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.

Updated Excel for Windows · keyboard defaults

Sources

  1. Keyboard shortcuts in Excel ↗