Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Insert blank rows on missing of numeric serial
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.