Increment in column field.

[Guest]

Hello -

This may seem easy to the Excel gurus out there so I would appreciate your
help.

I need to increment a number starting at 1 from A1:A1256 with it
incrementing just by 1.

1
2
3
4
and so on....

What formula could I use to accomplish this?

thanks,
mark

 

[Dave Peterson]

I'd put 1 in A1.

Then select a2:A1256 and type =a1+1 and hit ctrl-enter to fill that selected
range.

(Copy|paste special|values if you need to)

 

[Guest]

Try "=Row()", that way, if you delete a row, the numbers are still sequential.

Dale Preuss