Try this
in cell a1 key in 1, at A2 leave blank, at A3 key in2

select cells from A1 to A4 and then at the bottom right corner of the box,
the cursor will turn to a cross.

Drag down till you have the number of rows that you need.

"Paran" wrote:

1
skip
2
skip
3
skip
4
and so on...