Insert Alternate Blank Rows In Excel

Insert Alternate Blank Rows In Excel

Insert Alternate Blank Rows in Excel

‘Insert Alternate Blank Rows In Excel’ Inserting Rows & Columns in an Excel spreadsheet is a common thing but in few cases, we need to insert alternate blank rows in Excel. In this case we may think Macro is the only solution for this but, it is not so. In today’s article, I will teach you’ll the easiest way to add alternate blank rows in Excel. Look at the data in the following picture below where we need to insert alternate blank rows.

insert alternate blank rows in excel online

Most of the Excel users have been facing severe issues on how to add alternate blank rows in Excel. Hence, there is no need to write any Macro code for this. Following are the steps required to insert alternative blank rows.

  1. Insert an extra column after the last column. The name of the extra column can be anything. In the given image below I have inserted an extra column named Temp.
  2. Now fill the extra column with numbers. Over here I have filled the Temp field with numbers from 1 to 11.
  3. Then copy all numbers from D2:D12 and paste after the last filled cell on the same column, that is in D13, refer to the following image for to insert alternate blank rows in excel


  1. Then place your cell position anywhere in the Temp column that is the last column and click on the Sort icon (A to Z or Z to A). You can go to the sort icon by clicking on the Data tab and click on Sort & Filter group on the ribbon.


  1. After clicking on the Sort icon Excel Sheet will look like this.insert alternate blank rows in excel worksheet


  1. Then delete the extra column, which is the last column (Temp). Now your data will have alternate blank rows. Refer to the below image where we have successfully entered alternate blank rows in the excel file.insert alternate rows in excel


That’s it! Follow the above-given steps carefully and you will be able to insert alternate blank rows in excel easily. Hope you enjoyed this article. Feel free to write your comments and queries in the comment box. Stay connected and Win Excel with me.


This Post Has 15 Comments

  1. Willian

    I used to be recommended this website through my cousin. I’m no longer positive whether or
    not this submit is written through him as
    nobody else know such specified approximately my difficulty.
    You are amazing! Thanks!

  2. Aescat Replica

    constantly i used to read smaller articles which also clear their motive, and that is also happening with this post
    which I am reading at this time.

  3. air Bar flavor

    Thank you for the good writeup. It in fact was
    a amusement account it. Look advanced to more added agreeable from you!
    However, how could we communicate?

  4. aescat replica

    It’s going to be ending of mine day, however before finish I am reading this
    impressive post to increase my experience.

  5. It’s very trouble-free to find out any topic on web as compared to books, as I found this paragraph at this web site.

  6. Janis

    You made some good points there. I looked on the net for additional
    information about the issue and found most people will go along with your views on this site.

  7. Shay

    I am extremely impressed with your writing skills and also with the
    layout on your blog. Is this a paid theme or did you customize it yourself?
    Anyway keep up the nice quality writing, it is rare
    to see a great blog like this one these days.

  8. Louisa

    Wonderful beat ! I wish to apprentice while you amend your site, how
    can i subscribe for a blog site? The account
    aided me a acceptable deal. I had been a little bit acquainted of this your broadcast provided
    bright clear concept

  9. Adan

    I’ve been browsing online greater than three hours lately, yet I by no means found any attention-grabbing article
    like yours. It’s pretty price sufficient for me.
    In my view, if all webmasters and bloggers made just right content
    material as you probably did, the web will be a lot more helpful than ever before.

  10. Jackson

    I have been surfing online more than 2 hours today, yet I never found any interesting article like yours.
    It’s pretty worth enough for me. Personally, if all
    webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.

  11. Bennett

    Awesome blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple adjustements would
    really make my blog shine. Please let me know where you got
    your design. Cheers

  12. Melvin

    I’m not sure where you’re getting your information, but
    great topic. I needs to spend some time learning much more or understanding more.
    Thanks for wonderful information I was looking for this
    info for my mission.

  13. Agen338

    Thanks again for the article. Awesome.

  14. aescat

    Hi there! This is my first visit to your blog! We are a team of volunteers and
    starting a new initiative in a community in the same niche.
    Your blog provided us beneficial information to work on. You have done a marvellous job!

Leave a Reply