Repeating a sequence of numbers down a column

N

Nexan

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...
 
P

Peo Sjoblom

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
 
Top