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

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

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

oops, I want to count up to 2,000 in that sequence/series

So how do we know what comes after 6 ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
oops, I want to count up to 2,000 in that sequence/series

what I tried was to put in cell A5 "=A1+1", and in cell A6 "A2+1", and
in cell A7 "A3+1", and in cell A8 "A4+1, and then I tried to do a
"fill down", but it starts to repeat numbers so that won't work. I
just want a list of numbers 1 through 2,000 and in the order as shown
in the sample. Sorry, if I am not explaining myself properly, and
thereby causing confusion.

If I understand you correctly, your sequence shouldn't be 1, 5, 9, 13
but 1, 21, 41, 61 and then add 1 each time. This would make your first
column of labels then 1, 2, 3, 4, etc.

DQ

On May 2, 1:22 pm, dq wrote:
If I understand you correctly, your sequence shouldn't be 1, 5, 9, 13
but 1, 21, 41, 61 and then add 1 each time. This would make your first
column of labels then 1, 2, 3, 4, etc.

DQ

not really, your way would just put the number at the top of each
column, whereas I want the numbers to fill the columns

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