Edit a cell that already has something in it
75%
Typing into a cell that already holds something replaces it entirely. That is usually what you want, and occasionally a disaster, which is why the next thing to learn is that Ctrl+Z undoes the last change, as many times as you need.
To change part of a cell instead of all of it, press F2 or double-click the cell. The cursor goes inside, and the arrow keys move through the text rather than jumping to the next cell.
Someone typed an extra zero: B3 says 1200 when the order was for 120. Correct B3 so it reads 120.
B3
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Ordered | |||
| 2 | Envelopes | 250 | |||
| 3 | Folders | 1200 | |||
| 4 | Label sheets | 95 | |||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 |
Click a cell and type. Enter commits, Tab moves right, F2 edits in place, Ctrl+Z undoes. Drag the small square at the corner of a cell to fill. Ctrl+Enter checks your answer.