Skip to content

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. 1

    Type 1. Click A2 and type 1, then press Enter and click A2 again.

  2. 2

    Open Series. Home tab › Fill › Series… (keys: Alt, H, F, I, S).

  3. 3

    Set it up. Series in: Columns · Type: Linear · Step value: 1 · Stop value: 200.

  4. 4

    Click OK. Excel writes 1 to 200 down column A instantly.

MethodHowBest when
2 · Double-clickType 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 + dragType 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 · FormulaType =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)
Pro trick: type A2:A201 in the Name Box › Enter › type =ROW()-1 › press Ctrl+Enter. All 200 numbers in one keystroke.