If you copy cell A2, containing =A1+1, down into A3, the formula will become
=A2+1.
--
David Biddulph

Milan L wrote:
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

"Pete_UK" wrote:

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

On Sep 4, 11:44 pm, rafonss
wrote:
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?