Fill one value down a column
50%
The small square at the bottom-right corner of a selected cell is the fill handle. Dragging it copies the cell into everything you drag across. It is the difference between a minute of typing and a second of dragging, and later it is how formulas get applied to a whole column.
Nobody is ever shown the fill handle. It is a four-pixel square that happens to be one of the most used features in the program.
Every order in this list carries the same 0.2 tax rate. Put 0.2 in C2, then drag its fill handle down to C7 so all six rows have it.
C2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Net | Tax rate | ||
| 2 | A-101 | 320 | |||
| 3 | A-102 | 180 | |||
| 4 | A-103 | 640 | |||
| 5 | A-104 | 95 | |||
| 6 | A-105 | 410 | |||
| 7 | A-106 | 255 | |||
| 8 | |||||
| 9 | |||||
| 10 |
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.