💻 Software
Autonumbering a column in Excel
Fresh7 days ago
Mar 15, 2026196672 viewsConfidence Score0%
0%
Problem
In my first column, I want to autonumber it from 1, 2, 3, 4, ..., x. How do I do that?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Autonumbering a column in Excel
Low Risk
Normally, you just fill A1 in with 1, fill A2 with the formula =A1+1, and then drag the black box on the bottom right of cell A2 down as far as you want to go. Alternately, you can always just use =ROW() to have to output the row number of the cell.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix