How to Fill Selected Cells with Ctrl Enter

What Ctrl + Enter does

After selecting a range or several nonadjacent cells, type the entry and press Ctrl + Enter instead of Enter. Excel commits it to all selected cells.

Use the shortcut step by step

1. Select the full target range or use Ctrl to select nonadjacent cells.
2. Type the value or formula without pressing Enter.
3. Press Ctrl + Enter.
4. Inspect the first, middle, and last selected cells.
5. Undo immediately if the selection included cells that should not change.

Common shortcut mistakes

Mistake	Risk
Selecting populated cells unintentionally	Existing data is overwritten.
Pressing Enter alone	Only the active cell receives the entry.
Using a relative formula without checking results	References can adjust by cell position.
Applying it to merged cells	Merged selections can behave unpredictably.
Filling blanks without first selecting blanks only	Use Go To Special when existing values must be preserved.

How formulas behave with Ctrl + Enter

If you select B2:B10, type =A2*1.05, and press Ctrl + Enter, Excel enters a corresponding formula in every selected row. B3 will normally become =A3*1.05, B4 becomes =A4*1.05, and so on because the reference is relative. If you intended every row to use one fixed assumption in F1, write =A2*$F$1 before committing the selection.

This is powerful for filling nonadjacent cells, but it also overwrites every selected cell. When the goal is “fill blanks only,” first use Go To Special to select blanks inside a bounded range. After Ctrl + Enter, inspect several cells across the selection and use Undo immediately if the range included formulas, totals, or existing values that should have been preserved.

Use Ctrl + Enter with nonadjacent cells carefully

Holding Ctrl while selecting B2, B5, B9, and B12 creates a nonadjacent selection. Type one approved value and press Ctrl + Enter to place it in all four cells. This is useful for sparse updates, but the selection is easy to lose with one accidental click. Before typing, glance at the highlighted cells and confirm none contain formulas or existing values that should be preserved.

Use Undo as part of the workflow

Because Ctrl + Enter changes every selected cell in one action, check the result immediately before doing anything else. If the selection was wrong, one Undo can usually reverse the entire multi-cell entry. That safety is lost once several unrelated edits follow.

Frequently asked questions

Do formulas adjust in each cell?

Relative references usually adjust based on each destination cell.

Can I use nonadjacent cells?

Yes. Select them first, type once, then press Ctrl + Enter.

How do I fill only blanks?

Select the range, use Go To Special to select blanks, then use Ctrl + Enter.

Can I undo the whole operation?

Usually one Undo reverses the multi-cell entry when performed immediately.