Undo and redo
Don’t be afraid of mistakes: Excel remembers your recent actions and lets you undo them.
Ctrl+Z — undo
Undoes the last action (typing, deleting, formatting, moving). Press it repeatedly to step back several times.
Ctrl+Y — redo
Re-applies an undone action. Ctrl+Shift+Z also works in some versions.
When it doesn’t work
The undo history is cleared when the file is closed, so save (Ctrl+S) before big changes.
Tips
- The arrow next to the Undo button on the ribbon lets you undo several actions at once.
- Ctrl+Z is the most used shortcut in Excel.
Try it in the simulator
Change the price in C2, then delete B3. Press Ctrl+Z twice to undo both, then Ctrl+Y to redo one.
Книга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