Module 01 · Lesson 03
Numbering 1 to 200
Four ways to number a list, and the one that never skips a number.
Excel basics6 min
Method 1 · Fill Series (exact, no dragging)
- 1
Type 1. Click A2 and type 1, then press Enter and click A2 again.
- 2
Open Series. Home tab › Fill › Series… (keys: Alt, H, F, I, S).
- 3
Set it up. Series in: Columns · Type: Linear · Step value: 1 · Stop value: 200.
- 4
Click OK. Excel writes 1 to 200 down column A instantly.
| Method | How | Best when |
|---|---|---|
| 2 · Double-click | Type 1 in A2 and 2 in A3, select both, double-click the fill handle (small square, bottom-right). | The item list is already there: it fills to the last row with data next to it. |
| 3 · Ctrl + drag | Type 1 in A2. Hold Ctrl and drag the fill handle down to row 201. | Quick short lists. Without Ctrl, Excel just copies 1, 1, 1… |
| 4 · Formula | Type =ROW()-1 in A2 and fill down. In Excel 365/2021, =SEQUENCE(200) once spills 1–200. | Always: formula numbers renumber themselves when you delete a row. |
=ROW()-1 =SEQUENCE(200)