Fill a column with sequential numbers

G

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,
 
P

Peter1999

Just type "1" in the first cell, "2" in the second cell, and use your
mouse to drag the right/lower side down to 200..., excel will fill them
for you
 
D

Desert Piranha

GISDude said:
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,HI GISDude,
Click to expand...
You could put a 1 in your top cell, then right click on the little
square, and drag down to your destination.
When you release the mouse, then select "series".
 
D

Desert Piranha

GISDude said:
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,HI GISDude,
Click to expand...
You could put a 1 in your top cell, then right click on the littl
square, and drag down to your destination.
When you release the mouse, then select "series"
 
Top