You want in column A:
1, 5, 9, 13, 2, 6, ETC
How do we know what ETC is?
Do you want to repeat the 1,5,9,13,2,6 ?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
On May 2, 11:21 am, wrote:
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

I tried typing in the first 4 numbers and then in the next 4 cells
below that I siad to add 1 to the corresponding cell abovce, but it
starts to repeat shortly thereafter (see below)\
1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16
5
9
13
17
6
10
14
18
7
11
15
19