Is there any way to fill down a column with a repeating sequence of numbers?
In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
down with 1, 2, 3, 1, 2, 3, 1, 2, 3...

Put 1 , 2 3 in the first 3 cells, select them. right click and drag copy
down,
upon releasing the right mouse button you'll get an option of copy cells,
select it

--

Regards,

Peo Sjoblom


"Nexan" wrote in message
...
Is there any way to fill down a column with a repeating sequence of
numbers?
In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
down with 1, 2, 3, 1, 2, 3, 1, 2, 3...

Enter 1 at the top (A1 or whatever)
In A2, enter =MOD(A1,3)+1
Copy A2

"Nexan" wrote:

Is there any way to fill down a column with a repeating sequence of numbers?
In other words, instead of 1, 2, 3, 4, 5, 6..., I want the column to fill
down with 1, 2, 3, 1, 2, 3, 1, 2, 3...