Automatically list numbers in a column

[jball]

Hi techy peeps

Is there a way where when you add a new row, it will automatically add a new number to a column headed ID No.? If this is possible, and if I subsequently delete a row, can I make it re-number so that there are no gaps?

Thank you very much x

 

[Sir Vili]

Hi jball.

Try this in A2, if You want only row numers:

=ROWS($A$2:A2)

Then copy down.

BRGDS Sir Vili

 

[jball]

WOW thank you xx

On 2002-09-11 05:24, jball wrote:
Hi techy peeps

Is there a way where when you add a new row, it will automatically add a new number to a column headed ID No.? If this is possible, and if I subsequently delete a row, can I make it re-number so that there are no gaps?

Thank you very much x