Enter one formula into many cells in Excel

Enter one formula into many cells in Excel: Select, type, Ctrl+Enter (Mac: Select, type, Cmd+Return)

Windows	`Select, type, Ctrl+Enter`
Mac	`Select, type, Cmd+Return`
Group	formula

Practice this shortcut

Drill: Fill a block with one formula. Pro drill. Twenty-five drills are free.

What it does and when to use it

Select the range, type the formula once and press Ctrl+Enter. Every selected cell gets it, with references adjusted as if filled. It skips the separate fill step.

The common mistake

Typing the formula for the wrong cell of the selection. Ctrl+Enter writes it relative to the active cell, which is where you typed.

Related shortcuts

Total a whole block at once Select the block plus a blank row and column, Alt+=
Show formulas instead of values Ctrl+`
Create names from labels Select labels and values, Ctrl+Shift+F3, Enter
Insert a function by name Shift+F3, type the name, Enter
Add a note to a cell Shift+F2, type, Esc
The printable cheat sheet

Questions

What is the difference between Ctrl+Enter and Ctrl+D?

Ctrl+Enter writes the entry into the whole selection at once. Ctrl+D copies an existing formula down from the top cell of the selection.

Learn it by pressing it

Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.

Start the drill