Auto Serial No
 

Hi All,

If I write 1, 2, 3, in an excel sheet column & drag it to 30th column it
becomes a complete serail from 1 to 30 but when I delete one row i have to do
the same practice again, I also tried A1+1 & drag it but when I delete any
row it gives #Ref error is there any way to automate the serial.

Auto Serial No
 

Hi

Try entering in A1
=ROW()
And copy down

Row() gives the row number of the cell, so it will adjust automatically if
you delete rows.
If you insert a row, you will need to type =ROW() in column A of that row
--
Regards
Roger Govier

"Abdul Shakeel" wrote in message
...
Hi All,

If I write 1, 2, 3, in an excel sheet column & drag it to 30th column it
becomes a complete serail from 1 to 30 but when I delete one row i have to
do
the same practice again, I also tried A1+1 & drag it but when I delete any
row it gives #Ref error is there any way to automate the serial.