HOW TO INSERT BLANK ROWS IN EXCEL

Share on Social Networks

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

 

(Visited 194 times, 1 visits today)

Add a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Want access to ACCA Study Material of 2018-19?

Join Us Now to download the Latest ACCA 2018 - 2019 Study Material and Latest Post Notification?

Write your Email ID in the Below Box!

Thank You For Subscribing

Now write the paper names in the EMAIL and send it to

info@aglobalwall.com

Send your study material request at info@aglobalwall.com