HOW TO INSERT BLANK ROW IN MS EXCEL

 HOW TO INSERT BLANK ROW IN MS EXCEL 

If you work in MS Excel, then many times we need to insert a blank row after every row, so today we will learn how to insert a blank row in MS Excel in very easy and simple way. 

Step to Follow:-

Step1:- First, insert a serial number next to your data. For example , if our data is in the "G" column , click next to your data in the "H" coloumn and insert a serial number. Similarly , insert the next serial number in the next row. 

Step 2:- Now select both your serial number and move your cursor top the corner, then you will see that your cursor will change to plus sign, now you have to click twice with your mouse, then you will see that your serial numbers will be inserted automatically. 

Step 3:-Now you have to select all the serial numbers and paste them below your serial number.

Step 4:-Now you have to select all the serial numbers and select the SORT AND FILTER option from the HOME TAB in MS Excel and from this select your "Sort Smallest t Largest "option.

Step 5:- After this, a dialog box with "Warning "will pen , from this you have to select the option of "Expand Selection" and press OK.

Step 6:- Now you will see that all the serial numbers will be written twice and along with that blank row will also be inserted in your answer.

Step 7:- After this, you have to select all your serial number and delete them.  

Step 8:-Now you see that blank Row has been automatically inserted in your data very quickly. 

What we learned?

So today we learned how to insert a blank row in MS Excel. If you found this post useful, please like it and share it with your friends.