View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Increment in column field.

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)

MN wrote:

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