Fill every selected cell with Ctrl+Enter
Step 1 of 4
Ctrl+D copies a formula that's already in a cell. You can also select the cells first, write the formula once and press Ctrl+Enter to put it in all of them.
Click Continue when you're ready.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Units | Price | Total | ||
| 2 | Pens | 10 | 4 | |||
| 3 | Paper | 5 | 30 | |||
| 4 | Ink | 2 | 85 | |||
| 5 | Tape | 6 | 3 | |||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
Enter saves the text you are editing in the active cell only. Ctrl+Enter saves it in every cell of the selection and adjusts relative references for each one, as filling down would.
Common mistake: Pressing Enter after typing into a selection. Only the active cell gets the formula, and the cursor moves to the next cell in the selection.
The answer
- Edit the active cellF2
- Enter the same value in every selected cellCtrl+Enter
Select the cells, type the formula and press Ctrl+Enter (Ctrl+Return on a Mac). Each cell gets the formula with its references adjusted.
+5 points