Today you will

• fix part of a cell without wiping the rest
• undo a mistake in one click
• add five rows and edit three rows in {{code:05_project_budget}}

Warm-up

Have you ever typed over a cell by accident and lost what was there? What would you want the spreadsheet to do next?

Edit mode lets you change one letter inside a cell without retyping it all. You double-click the cell to open it.

Clear empties one cell. Delete row removes the whole row, so use it with care.

Undo brings back what you just changed. Redo puts the change back again.

Fill-drag carries a pattern like 1, 2, 3 down a column.

Example

You clear the wrong cost by mistake. You press {{kbd:Ctrl+Z}} ({{kbd:Cmd+Z}} on a Mac) and the old cost comes back.

You will make a short practice sheet that has some mistakes in it on purpose. Copy the table below, then follow the steps in the box underneath. This file is only for practice.

Common problems

• I typed over a cell and lost the old text. Press {{kbd:Ctrl+Z}} ({{kbd:Cmd+Z}} on a Mac) straight away. Next time, double-click the cell first.
• A whole row disappeared. You chose Delete row by mistake, so press Undo once.
• Fill-drag copied the same number down. Undo it. Type 1 and 2, select both cells, then drag again.