I want to number a long column like A1 - A500 consecutively

  • Thread starter Thread starter James Wintner
  • Start date Start date
J

James Wintner

So that each number is the preceding number plus one. It is for a long
list of auction items and this will iterate the lot numbers (1-500 in
this case). (there will actually be 10,000, so I don't want to type in
each one.

I already found a macro that will create a specified number of rows,
if that helps.

Thanks
Jim
 
Put 1 in your first cell and 2 in your second cell. Highlight both
those cells and then drag the fill handle (the small black square in
the bottom right corner of the cursor) down for as many cells as you
need.

Another way is to put 1 in your first cell then highlight all the
cells that you want incremented and then click on Edit | Fill | Series
and choose an increment of 1 and click OK.

A third way is to put 1 in your first cell (assume A1) then in A2
enter this formula:

=A1+1

then copy this down as far as you need.

Or you could put:

=ROW(A1)

in your first cell, and then copy this down.

Hope this helps.

Pete
 
Assuming the 10,000 items are in column A

In B1 =row()

Double-click on the fill handle of B1 to copy down to end of data in A

Or in B1 enter 1 then in namebox type B1:B10000 and ENTER

Edit>Fill>Series>Step Value of 1...........no need for Stop Value


Gord Dibben MS Excel MVP
 
Thank you all for your great and quick answers. Seems like Edit/Fill/
Series is the easist appraoch. I tried it and it worked perfectly.

Thanks again,
Jim
 
Back
Top