put in the 1 and 5 in A1 and A2, then use the fill handle to create
9,13,17,21,25,... as far down as you want.
Bob Umlas
Excel MVP
wrote in message
oups.com...
pls help, is there an easy way to fill down a column with numbers in a
certain sequence? I want to go down a column; cell A1 would be 1, A2
would be 5, A3 would be 9, A4 would be 13, A5 would be 2, A6 would be
6, etc., , I want to end up with a column of numbers that I can paste
into a label program. My problem is that the labels are 4 across and
20 up and down, and I want the numbers to go down the column instead
of across, which is what happens when I just put consecutive numbers
in it, but if I could have every 4th number count then it would work
I think