Fill a column with sequential numbers

[GISDude]

Hi all.
I know i've seen this before.
Let's say i have a worksheet with 200 records and various fields. I
want to add another field labeled "Lot" and want to populate it
seqentially from 1 to 200. Now, I could do this manually and add them
in 1 by 1, but I could swear I've seent a trick that will do it from 1
to 200.

Any tip/idea would be appreciated.
Thx,

 

[via135]

hi!

it would be helpful if u furnish the names of various *fields*

-via135

 

[Gord Dibben]

Assume "Lot" is in C1

In C2 enter 1

Select C2 and in namebox type C2:C2002 and <ENTER>

Edit>Fill>Series>Linear>Step Value: 1 and OK

OR...............

Enter a 1 in C2 and a 2 in C3.

Select both cells and drag/copy down to C201


Gord Dibben MS Excel MVP

 

[Guest]

Try this:

Put a 1 in the first cell
<Edit><Fill><Series>
Series in: (check rows or columns)
Type: Linear (the default)
Step value: 1 (the default)
Stop Value: 200
Click [Enter]

That will fill in the row or column with values from 1 through 200.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[GISDude]

it works. thanks very much.