How to insert multiple blank rows in-between rows of data (Excel) 

So simple, yet never thoght about this solution. YOU ARE A GENIUS

i used this video last year for work and it saved my life. im using it again this year and it is still so good. thank you so much

Thank you, Victor. Exactly what I needed for an odd one-off task.

Thanks, Victor. Such a simple solution and yet it would have taken me so long.

I have 250 rows that need 1 blank row in between. And this video has helped a lot. Thank you very much!!!

You just saved me hours of work, thanks!

Thank you! This is exactly what I needed. Well explained and so simple once you know how.

Thank you 🙏🏻, you can’t believe how I have been struggling with this

Thank you!

dude, that was the slickest simple trick ever...the number of hours i've wasted inserting rows the hard way.

You are such a savior. This is so helpful.

Thanks for saving me a ton of of time!

My friend, you are a legend! Thanks!!!

My only regret is not finding this video sooner 👏🏼

Wow. Very brilliant solution. Learned something new. Thanks for sharing

This was super helpful. Thank you!

This is sooooo smart! Okay I am subscribing. Thank you sooo muuch!!!!!!!!!!!!!

learned something great today

Thank you! Very Helpful!

Brilliant have been looking for this for a while I had data for like 2000+ rows

Thank you

Thank you so much ..it's working for my tasks perfectly..4 hours reduced to 1 hour

Thank you. Very helpful

Great idea! Thank you.

thank for shearing this is the good one that I finding

smartest thing ive seen in a long while. Thank you

well this was one of the best tricks. ✌

So simple yet soooooo brilliant!!!

This thing I was searching for everywhere thanks

Brilliant and simple!! Thank you - saves a lot of time

Thanks Victor! 👍

Super helpful thanks!

What would be also interesting is how how to sort a column and insert 2 blank lines when the first 3 characters of a cell changes AND insert a subtotal in column "e". Column 1 has many rows where the first 3 characters do vary. A macro for this would be great. I can't find a way to do this.

Wow.Thanks for Sharing.One more trick in the bag.

Hi. What a lot I learned from you in a short time. Wow! Thank you! Could you please tell me, for example, how to insert 3 rows, taking as reference the data from the first column which are products items/codes, therefore multiply the data in those rows and in the second column will be the origin country of that product. And at the end a product has 4 rows with different countries of origin.

Thanks a lot , realy helpful tip !!!

Thanks Bro for this thread

That was Genius!

this was brilliant! thnaks

Loved it.

Great !

ahhh thank you!!!!!!!!!!!!!!!!!!!!

fantastic

Is there any way to add a blank row without number? For example 20 21 22 23 24

I have 1000 rows, How do I add a blank space/empty row after every 30 rows?

Sequence to the rescue here as well....

HOW CAN INSERT A BLANK ROW AFTER EACH DUPLICATE VALUE

Can you use it on columns?

I have 969 rows and I want to add 2 blank rows below each. This trick is not working . after 134 rows the number of blank rows from 2 to 4 blanks.

Such a very brilliant, useful, and fantastic time (and energy) saver! Thank you, my Friend! I'll never get those wasted hours back again, but that is over with now! You're the best! Thank you! Thank you! And, of course, THANK YOU!!! ~I wish all Good Beings here a Happy and Healthy 2023 ...and Beyond. Oh, yeah ...THANK YOU!!! ~Most Gratefully, Wombat Willie ʕ•́ᴥ•̀ʔっ

I need 6 blank rows after each 10 rows how to do that?

Hi brother, in my case, there are 10,000 serial numbers & around 1110 blanks rows have to be inserted between each of those 10,000 serial numbers. Is this possible ?

Very good trick but for huge data how is possible?. Can u share the tricks?

Hnmmm...

terrible video, all i wanted was how to insert rows and you moving so fast. very bad

Thank you