Question Locked

Insert blank rows on missing of numeric serial

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Respected sir,

I want to insert blank rows on missing of numeric serial. Like wise

Ser # Name
1 Asghar
2 Ali
4 Shafi
8 Navid
10 Karim

As mentioned above there is missing of serial numbers 3,5,6,7,9. My plea is that MS Excel should automatically generate blank row (Using formulas or Code) in lieu of missing serials.

1 reply

This discussion is closed to new replies.