Inserting Blank Rows In Between Data Rows In Excel




About this tutorial:

Video duration: 2:58
Inserting Blank Rows In Between Data Rows In Excel

In this tutorial, you will learn how to add blank rows in between 100s and 1000s of existing data row items, and too, without Macros. Time taken is less than 10 Seconds.

This Advanced Excel Tutorial file shown in the video is available for FREE download at

Enroll our FREE Course at

Keep yourself updated. Follow us now!
Like us on
Tweet us on…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

45 thoughts on “Inserting Blank Rows In Between Data Rows In Excel

    Christian MC

    (October 13, 2017 - 1:38 am)

    You are a genius thank you!

    Anurag Jain

    (October 13, 2017 - 1:38 am)

    how to do the same operation while adding a blank row after nth rows..say after every 7 rows ?

    Gurjeet Singh

    (October 13, 2017 - 1:38 am)

    Thanks

    HeidiGoodall

    (October 13, 2017 - 1:38 am)

    You are so smart, thank you thank you!!

    yesuratnakumari renee

    (October 13, 2017 - 1:38 am)

    Super bro

    Gran Santiasco

    (October 13, 2017 - 1:38 am)

    how can add two columns instead of one, between two cels… i mean: two data celds and then two blank columns, and loop this. :(??

    Sandeep Bhatt

    (October 13, 2017 - 1:38 am)

    Blank row के बाद यदि सर अब नम्बर डालने हों तो अब नम्बर कैसे पड़ेंगे। जबकि बीच में एक blank row है।
    Tell Me

    MrWebon

    (October 13, 2017 - 1:38 am)

    How can I hide the blank cells, and later if needed show them again?

    Mina Tehrani

    (October 13, 2017 - 1:38 am)

    Thank you! This is exactly the trick I have been looking for for days.

    Kamthe omkar

    (October 13, 2017 - 1:38 am)

    cool

    Vibin K

    (October 13, 2017 - 1:38 am)

    Wow . Great tip. Thank you

    Basem Al-Qadasi

    (October 13, 2017 - 1:38 am)

    Thank you very much for this helpful tips, but if I want to insert blank row between each two or three data rows

    Louie Brilliantes

    (October 13, 2017 - 1:38 am)

    Thank you for the tip. It was most helpful
    May i ask how you superimpose yourself speaking on the youtube screen?

    Carlos Ferreira

    (October 13, 2017 - 1:38 am)

    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

    Kiran Kulkarni

    (October 13, 2017 - 1:38 am)

    This really helped 🙂 Thank you

    Meghan Tharp

    (October 13, 2017 - 1:38 am)

    Thank you for posting this. This was a great help!

    Shiva Krishna

    (October 13, 2017 - 1:38 am)

    hats off sir

    Tony Nesavich

    (October 13, 2017 - 1:38 am)

    Outstanding Yoda! Jedi master you are! Thanks for posting.. I used this, will be using it for script generation many times! Good on you mate!!! 🙂

    Vijay Pal

    (October 13, 2017 - 1:38 am)

    Awesome !

    Sunny Sung

    (October 13, 2017 - 1:38 am)

    Awesome video. Thank you for sharing.

    Jayesh Sindhvad

    (October 13, 2017 - 1:38 am)

    Very good Technic Thank you!

    Navjeet Chhabra

    (October 13, 2017 - 1:38 am)

    Simple and Smart..!

    MyNameHere

    (October 13, 2017 - 1:38 am)

    Brilliant! Thanks so much!

    Abu-hamza Ahmadzai

    (October 13, 2017 - 1:38 am)

    Great job, It was helpful. Thank you so much.

    Eugene Stalmeester

    (October 13, 2017 - 1:38 am)

    it's like magic 🙂

    Lee Grey

    (October 13, 2017 - 1:38 am)

    So helpful! thanks!!!!

    IMAANGEMS COLLECTION

    (October 13, 2017 - 1:38 am)

    (IGC) GREAT INFROMATION VERY HELPFULL KEEP IT UP THANKS FOR THE BEST INFROMATION I WAS TOO MUCH CONFUSED BUT WHEN SAW THAT VIDEO ALL THINGS LOOKS VERY VERY EASY THANKS

    siva kumar

    (October 13, 2017 - 1:38 am)

    Awesome trick… Love it.. Can u plz teach me macro

    RAJA RAO

    (October 13, 2017 - 1:38 am)

    Very gud one. How about if I want to add more than one Row? Also for Columns???

    CA. Kannan Iyer

    (October 13, 2017 - 1:38 am)

    good one

    Baluma1

    (October 13, 2017 - 1:38 am)

    So simple and SO USEFULL … and I was using it before in a different way but this didnt come to my mind when I needed it xD Thanks

    yemi atteh

    (October 13, 2017 - 1:38 am)

    thats a nice one, how do you remove the blank rows in more sense getting the data back to its original form when it has no dummy sn?

    يوسف العمري

    (October 13, 2017 - 1:38 am)

    THANK YOU SO MUCH!

    Cynthia Ferrufino

    (October 13, 2017 - 1:38 am)

    Thank you so much this is great!

    Hopbest

    (October 13, 2017 - 1:38 am)

    thank u it is a great help

    Radu Z

    (October 13, 2017 - 1:38 am)

    Thank you!!!!

    Kevin Mui

    (October 13, 2017 - 1:38 am)

    you freaking genius!

    peter liba

    (October 13, 2017 - 1:38 am)

    How would you add 2 blank rows

    Ioan Buda

    (October 13, 2017 - 1:38 am)

    Thank you !

    MegaAnonymous2012

    (October 13, 2017 - 1:38 am)

    Can I insert a blank row after a certain number of rows, like i have a sheet with 10,000 entries and I want to insert a blank row after every 5 rows, how do I do that ?

    tarun sai

    (October 13, 2017 - 1:38 am)

    This is very helpful… but i want a shortcut are a trick to delete unwanted data in the middle of the data…. plz help me out..

    Harsha Vardhan Seshapu

    (October 13, 2017 - 1:38 am)

    Having Trouble in insert option that will be appeared after right click.
    If i need to add a new row in the excel sheet, when i select a entire row and right click to select the insert option it was not happening, as the insert option turned into gray in color so how to get it back into black in color.
    same for cut option too..

    Is there any suggestions ??

    quantdude24

    (October 13, 2017 - 1:38 am)

    BLESS YOU MY FRIEND 🙂

    kcpurplepower1

    (October 13, 2017 - 1:38 am)

    How would you add a row or two rows to seperate North, South, East and West?  Keeping North data together, South data together, etc. but having a row in between.

    Ironbuket

    (October 13, 2017 - 1:38 am)

    What I find really annoying is that if you copy a row, there seems to be no way to insert a blank row. You can only insert the line you copied

Leave a Reply

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