Autonumbering a column in Excel

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.

For most sequences, you can do this:

• Start typing them down the column (like 1, 2, 3 or 2, 4, 6, or Monday, Tuesday, Wednesday)
• Highlight the portion you have filled in
• Grab the bottom right corner of the highlighted selection and drag it down and Excel will fill in the rest of the sequence

=1+R[-1]C As you can check on the Microsoft Office Online Help, Excel doesn't have any tool for doing that, but you can fill it with the ROW function...

use the fill down option under one of the menus