Auto Serial No

  • Thread starter Thread starter Abdul Shakeel
  • Start date Start date
A

Abdul Shakeel

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.
 
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
 
Back
Top