View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GISDude
 
Posts: n/a
Default Fill a column with sequential numbers

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,