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.
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.
- 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.
- Now fill the extra column with numbers. Over here I have filled the Temp field with numbers from 1 to 11.
- 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 this.
- 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.
- 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.
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
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!
Everyone loves it when folks get together and share thoughts.
Great website, stick with it!
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.
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?
It’s going to be ending of mine day, however before finish I am reading this
impressive post to increase my experience.
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.
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.
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.
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
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.
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.
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
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.
Thanks again for the article. Awesome.
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!