Microsoft Excel - retain autonumber sequence after deleting a row in excel

Asked By Rajender Prasad on 23-Jul-14 04:38 PM
hi All,

How to retain autonumber sequence after deleting a row in excel.
1
2
3
4
5

if I delete a row 3, then excel should automatically adjusts
1
2
3
4
.. Please help me to get this done.

Thank you so much in advance

Regards,
Prasad      
Harry Boughen replied to Rajender Prasad on 26-Jul-14 03:35 AM
Hello Prasad,
You could try using something like setting the numbers with =ROW().
If your rows and index number do not coincide you could add or subtract a constant as appropriate.
Regards
Harry