AutoFill (Fill)
Filling is a quick way to copy a value or formula into neighbouring cells.
The fill handle
Find the small square in the bottom-right corner of the selected cell. Drag it down or sideways and the value or formula is copied.
Filling formulas
Drag =B2*C2 from D2 downward and D3 gets =B3*C3, D4 gets =B4*C4 — Excel shifts the references for you.
Double-click and Ctrl+D
Double-click the handle to fill the formula down to the end of the data in the next column. Ctrl+D copies the cell above downward.
Tips
- Type 1 and 2 into two cells, select both and drag — Excel continues 3, 4, 5…
- Month names and weekdays continue automatically too.
Try it in the simulator
Select D2 and drag the fill handle down to D5. Check the formulas in D3:D5 in the formula bar.
Книга1 - Excel
—☐✕
Буфер обмена
Calibri ▾11 ▾
Шрифт
Выравнивание
Общий ▾
Число
Стили
Ячейки
Редактирование
✕✓fx
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Product | Qty | Price | Total | ||||||||||||||||||||
| 2 | Bread | 3 | 4000 | 12000 | ||||||||||||||||||||
| 3 | Milk | 2 | 12000 | |||||||||||||||||||||
| 4 | Eggs | 10 | 1500 | |||||||||||||||||||||
| 5 | Tea | 1 | 25000 | |||||||||||||||||||||
| 6 | ||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||
| 10 |
Лист1
Готово
−+100%
Test your knowledge
Do graded exercises on these topics in the “Practice” section and earn coins.
Go to exercises