How to Add Serial Numbers (a Numbered Column) in Excel
A numbered index column sounds trivial — until the fill-handle sequence drifts after a sort, or you need invoice-style INV-0001. Here's the one-click way to insert a clean numbered column with any start, step, prefix, and zero-padding.
Last updated: August 2026
| Rows | Numbered column | |
|---|---|---|
| Widget | → | 1 · Widget |
| Gadget | → | 2 · Gadget |
| Gizmo | → | 3 · Gizmo (or INV-0003) |
Why the fill handle drifts
Type 1, 2, and drag the fill handle and it looks done — until someone inserts a row, sorts, or filters. Then the sequence has gaps or duplicates. Switching to =ROW()-1 keeps it contiguous, but it recomputes whenever rows move, so the number next to a given row changes under you. And a formatted serial like INV-0001 needs ="INV-"&TEXT(ROW()-1,"0000") — which is no longer a number you can sort or total.
The 1-click way — Tellsheet's Add Serial Numbers
Run Add Serial Numbers to insert a numbered column on the left. Set any start and step (1, 2, 3… or 100, 110, 120…), give it a heading, and optionally add a prefix (INV-) and zero-pad to a number of digits (0001). With no prefix or padding the values are real numbers you can sort and sum; add a prefix or padding and they become tidy formatted text. Pairs with Add Leading Zeros and Add a Prefix or Suffix.
Frequently asked questions
Will the numbers drift after a sort?
No — they're fixed values, not a ROW() formula. Re-run the tool if you add rows later.
Can it make INV-0001 style numbers?
Yes — add the INV- prefix and zero-pad to four digits.
Can I set the start and step?
Yes — any start and any step, e.g. 100, 110, 120.
Are they real numbers?
With no prefix or padding, yes — sortable and summable. A prefix or padding makes them formatted text.
Related Excel guides
Add a numbered column in one click
Add Serial Numbers inserts a running index — any start, step, prefix, and zero-padding — that won't drift when you sort or filter.
Get Tellsheet free See pricing