HOW TO INSERT BLANK ROWS IN EXCEL

(Last Updated On: August 18, 2017)

HOW TO INSERT BLANK ROWS IN EXCEL

In this video, you will learn how to insert blank rows in excel sheet? I know that you know it but I will show you a trick in this video. By this trick, you can add blank rows in a table after a regular interval. You can manage big data with this easily. You want to make the group of 3 days or 7 days and want to insert blank rows.

You can find out 7 days sale very easily, inserting manual rows is very difficult and time-consuming. This trick will save your time, and you can do it very easily.

HOW TO INSERT BLANK ROWS IN EXCEL

Formulas use in this Video

You can add a column by (Ctrl+ +sign), Sr. No   (=cell+1).

I have entered 7.1 and then add 7 in this formula, because I need 7 days gap. If you need 3 days gap you can add 3 in the formula. After that, you have to apply the filter and then you can see blank rows are added in the data. In the last step, you can remove the sr. no column and your data are ready now.

 

I hope you liked that video, please like this video and share it. And also don’t forget to subscribe my channel @ https://www.youtube.com/channel/UCy0CDL5hBPYfVaR4gCb6vOQ

 

Add a Comment

Your email address will not be published. Required fields are marked *