Learn › Excel › Fill a selection at once
Excel fill shortcut: Ctrl + Enter
Type once and fill every selected cell with the same value or formula.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + Enter finishes your entry and puts it into every selected cell at once. Type a word or a number and every cell in the selection gets it. Type a formula and each cell gets the formula, with its references adjusted to its own row.
When to use it
Use it to fill a Status column with the same word, to set a starting value in many cells, or to add the same formula to a whole column without copying it down. Select the empty cells first, then type.
How to do it
- Select the cells you want to fill: click the first one, then hold Shift and press an arrow key.
- Type a value or a formula. Do not press Enter yet.
- Press Ctrl + Enter (on a Mac: Control + Return). Every selected cell gets the entry.
A quick example
In the orders table, select E2 to E7, type Open and press Ctrl + Enter: all six cells say Open. Then select D2 to D7, type =B2*C2 and press Ctrl + Enter: every row shows its own total, 50, 32, 78 and so on.
Ctrl + Enter, Enter and Ctrl + D
A normal Enter fills only the active cell and moves down. Ctrl + Enter fills the whole selection and stays where you are. Ctrl + D copies the top cell down and Ctrl + R copies the left cell to the right, but they need a value to exist first, while Ctrl + Enter writes into empty cells directly.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- Only one cell was filled: you pressed Enter, not Ctrl + Enter. Press Ctrl + Z, select the cells again and use Ctrl + Enter.
- Every cell shows the result of the first row: the formula points at a fixed cell. Use a normal reference like B2, not $B$2.
- Cells that already hold data were overwritten: Ctrl + Enter replaces them without asking. Press Ctrl + Z to undo.
- On a Mac use Control + Return.
Quick answers
What does Ctrl + Enter do in Excel?
It enters what you typed into every selected cell at once, instead of only the active cell.
How do I fill the same formula into many cells?
Select the cells, type the formula for the first cell and press Ctrl + Enter. Each cell gets the formula with its own references.
Is Ctrl + Enter the same as Ctrl + D?
No. Ctrl + D copies the top cell of the selection down. Ctrl + Enter writes the new value you typed into all selected cells.
How do I fill a column with the same word?
Select the empty cells, type the word and press Ctrl + Enter.

