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.