Automatic numbering.. is this possible?

[BMills]

I have someone wanting to be able to have their A column number 1-500 automatically in each cell under A. Is there a way to do this?

Specifically, A1 would read 1, A2 would read 2, A3 would read 3, etc....
This message was edited by BMills on 2002-09-19 13:10

 

[s-o-s]

On 2002-09-19 13:09, BMills wrote:
I have someone wanting to be able to have their A column number 1-500 automatically in each cell under A. Is there a way to do this?

Specifically, A1 would read 1, A2 would read 2, A3 would read 3, etc....
This message was edited by BMills on 2002-09-19 13:10

A quick way is to use the row() formula paste this into Cell A1 also if you insert rows it allows this

=ROW()

If you need to adjust you can start numbering from row 3 by using

=ROW()-2

 

[BMills]

Excellent! That did it! thank you much!!