hi
in a1, enter 1
in a3, enter 2
in a5, enter 3
in a7, enter 4
this will leave a2,a4 and a6 blank.
high light a2:A7. DO NOT include a1 in the high lighted selection.
hover the mouse over the lower left corner of a7 until the mouse pointer
changes to a black cross. right click and hold...drag down as far as needed.
regards
FSt1