View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
vtrud vtrud is offline
external usenet poster
 
Posts: 21
Default Auto-fill numbers in groups of 4

Yep, I get how to do that but I don't want to do this all the way up to 2000.
Easier way to auot fill or something?

"Jim Thomlinson" wrote:

One way...

In A1 1000
In A2:A4 =A$1
In A5 =A1+1
Drag the formula in A5 down as necessary.
--
HTH...

Jim Thomlinson


"vtrud" wrote:

I would like to fill a column with progressive numbers in sets of 4 each.
For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so
on.

Ideas?
Thx, V