Deleting cells
Deleting in Excel means one of two things: clearing a cell’s value or removing a row/column entirely.
Clear a value
Select a cell and press Delete — the value goes away but the cell stays. Backspace clears it too and enters edit mode.
Delete a row or column
Select a row (Shift+Space) and press Ctrl+-. The row is removed and the rows below move up.
Effect on formulas
If you delete a cell that a formula refers to, the formula shows a #REF! error. Check dependent formulas before deleting.
Tips
- Select several cells and press Delete to clear them all at once.
- Seeing #REF!? Press Ctrl+Z right away.
Try it in the simulator
Select B4 and press Delete. Then select row 5 (Shift+Space in A5) and delete it with Ctrl+-.
Книга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 | |||||||||||||||||||||
| 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