Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In my first column, I want to autonumber it from 1, 2, 3, 4, ..., x. How do I do that?

share|improve this question

migrated from stackoverflow.com Apr 13 '10 at 2:13

This question came from our site for professional and enthusiast programmers.

add comment

7 Answers 7

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.

share|improve this answer
4  
If you use ROW(), anchor it to the first cell with =ROW()-ROW(A$1), so you can move the cells around. –  Mark May 5 '09 at 10:27
    
=ROW()-ROW(A$1) is good, because it handles row deletions well. –  mg1075 Jul 25 '12 at 21:17
add comment

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
share|improve this answer
add comment

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

share|improve this answer
add comment

use the fill down option under one of the menus

share|improve this answer
add comment

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

Quoting:

  • Select the first cell in the range that you want to fill.
  • Type the starting value for the series.
  • Type a value in the next cell to establish a pattern.

For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4.

  • Select the cells that contain the starting values.
  • Drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.)
  • Selected cell with fill handle across the range that you want to fill.

To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

share|improve this answer
add comment

In the first row type 1, in the second row put this formula:

=IF(B2>0,SUM(A2+1),"")

and drag all the way down in the sheet.

share|improve this answer
add comment

The simplest solution is to use the tables feature of excel - it provides you a column with implicit (calculated) formula which is expanded to all new rows in such table.

E.g. if you'd like to create autonumber in this format:

1/2/.../187/...

Insert this formula in the column of the table where autonumber should be placed:

=ROW()-ROW(Table1[[#Headers];[AutoNum]])

(replace table name with yours - here "Table1", and change reference to name of the autonumber column name - here "AutoNum")

If you'd like to create text autoID in this format:

"RowID_001"/"RowID_002"/.../"RowID_187"/...

Insert this formula in the column of the table where autoID should be placed:

=CONCATENATE("RowID_";TEXT(ROW()-ROW(Table1[[#Headers];[AutoNum]]);"000"))

(the format of number within autoID is defined by the string in the TEXT formula )

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.