Insert Blank Row After Every Data Row In Excel- Excel Tip 

After searching for 3 months I stumbled upon this video. An answer directly from God's child! You saved me HOURS of work!

Thank you so much you saved my 3 hours

Thank you - you are a life saver. i had 10000 rows that needed this

This video really helped me in inserting no of rows in between the rows with data. Thank you

Thanks! Can't believe I didn't think about this. This made it so easy.

Such a clever workaround. Thank you so much for the tutorial!

That was very smart! I learnt something new! Thank you!

I've been looking for this!! Thank you.

Wow...such an easy way

Clever! Much better than using VBA. Two thumbs up.

Thank you so much - a real time saver!

Good technic.... thankyou very much

Wow! It's clever!

Excellent thanks

Perfect, just what i needed.

Thank you so much 🥰🥰

The beauty of simplicity makes my soul smile

very nice technique. thank you

I'm in love with your voice ;) . thanks for the info.

Thanks! Such a low tech solution to a seemingly difficult problem. :D

Lovely God bless you

Thank you!!!

Mind-blowing thank you so much

woww awesome, thank you so mutch, perfect idea

Too smart. Thanks for the great video

Very clever. Nicely done.

Thanks!! U're an angel!

Very simple awesome

Thank you so much, very nice

Too clever by half!!! Thank you.

Thanks its really helpful

this is great! Thanks!

Thank you so much for this

Thank you so much!

Thank you very much!

Perfect idea

Love it!

Thanks

Thank you very much

your amazing thank you love you

Nice work! I needed to add 9 rows in between 1000 rows... so I just copied the left collumn 9 times before sorting it and done!

Excellent

Great!

Wonderful ❤️

lol genius,thanks

Superb

I am such an idiot. So simple method. Thanks!

Thank you madam

This is gold!!!! Although I have another question. What if I want to divide my data into batches? Lets say I have 1000 rows and I want to convert them into batches of 10 rows?

OOMG, it is like magic

What if I want to insert one blank row after text and the may not have uniform pattern

thats the trick, thanks. is there a proper way to did that? it would be great

Very good could you teach me how to add more then one row? Thanks

Good

How can I accomplish this in Google Sheets?

Wow

This Helps (y)... What if I need a Blank row after every 7 rows ?

I want to automatically insert new row whenever i enter data in the first column last row of the table i work with in my workbook just like Access tables do. Can any body give me some vba code to do so.???

Really Brilliant and smart, Thnx

No, I have tried it and it does not work. I have 1451 rows and it does not work. what do you suggest I do? Please advise. Thanks TJP

How to insert multiple rows after a particular name column?

What to do if i need 50 rows between each rows? Copy 50 times? 😢 so hard

Hello! Good Morning I am new to VBA Excel, maybe you can help me. I am creating DB in just one worksheet, with 3 UserForms: UserForm Customers with the button that call the, Service UserForm with the button that call the, UserForm Type Services. I want to know if it's possible. 1- If the Service was paid in Check, I need to add 3 columns or Line Verification Number, Amount and Date. 2- If the service was paid per day I need to add 3 columns or line 01/25/2017 - day of travel, 01/26/2017 - full day - 01/27/2017 - Day trip. I also need a code that tells the worksheet how many rows have been added for the next record to skip. Example: We have the word "Per Day" in column P6. We need to add 3 rows, the next record has to be added in column A10. Thank you very much

Lolx that was great

OSAM

how to insert 5 rows in after every data row

MY PROBLEM SOLVE

How to insert duplicate rows in excel

How to add column???

JULY THURSDAY 11

So, with some testing, this procedure works for a week at a time, but if tried for any more days it doubles some days up. Hum!🤔

I am trying it is not working

hmmmmmmm

Ya, all videos regarding this subject do not work for me. I have a column of Days of the year, that I want to add 6 blank spaces between each date. I get all the 1's together and the dates separated by 7 Jan. 1, Jan 8, Jan 15, etc. with No spaces in between. Bum.

Omg I've doing wrong all my life

Thank you so much!!!!