R
rafonss
I would like to start numbering 1 - 500 in a column and 1 - 30 in a row. Is
there some way to do this with a function?
there some way to do this with a function?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
There are many ways of achieving this, but if you want a function then
the easiest is to put 1 in your starting cell (suppose this is A1) and
then in A2 put this formula:
=A1+1
and copy this down.
In B1 you can enter this formula:
=A1+1
and copy this across.
Hope this helps.
Pete
the easiest is to put 1 in your starting cell (suppose this is A1) and
then in A2 put this formula:
=A1+1
and copy this down.
In B1 you can enter this formula:
=A1+1
and copy this across.
Hope this helps.
Pete
D
Dave Curtis
M
Milan L
Hi,
this did not work for me. Copying =A1+1 in A3 always give me 2 instead of
number 3. am i reading your note correctly? thanks
this did not work for me. Copying =A1+1 in A3 always give me 2 instead of
number 3. am i reading your note correctly? thanks
D
David Biddulph
If you copy cell A2, containing =A1+1, down into A3, the formula will become
=A2+1.
=A2+1.
G
Glenn
Another option...in the first cell of the column you want to number from 1-500 put
=ROW(1:1)
and fill down as needed. In the first cell of the row you want numbered from
1-30 put
=COLUMN(A:A)
and fill right as needed.
=ROW(1:1)
and fill down as needed. In the first cell of the row you want numbered from
1-30 put
=COLUMN(A:A)
and fill right as needed.