Excel - Insert a blank row after every row or every Nth row

Do you ever need to add blank rows in between rows? There are several ways to do this in Excel, but if you have a lot of data, right-clicking and inserting rows becomes tedious. We will use a helper column to quickly add blank rows after every row. We will also look at inserting a blank row after every 3rd row or every Nth row.

Chapters:
0:00 Intro
0:12 Helper column for blank rows
1:15 Every 3rd row, a blank row

#chrismenardtraining #msexcel #excetraining #exceltips

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[april]

You saved my life, Thank you very much sir 🙏🙏
Love from India

[SanjogMainali]

You Saved my entire day of work and I finished it in 2 minutes, Now I can go for lunch and chill. Thanks alot

[christophe]

This was a great review and i can not believe i never thought of this. This became very handy as I have to do a lot of data loads into our ERP system and the way they built the integration load is if the same item has multiple suppliers attached to it, they each get their own row. so when I am loading hundreds of them, it is easier to have the space between them all rather then adding it when it is needed.

[calebbomske]

Well, that was extremely helpful. I feel stupid for not thinking of this before.

[zbsthic]

That's exactly the information I needed, thank you! REASON FOR A BLANK ROW: I have to insert a Document number from a table given in Word. Document number in Word are lined up in a column and they do not have a space in-between. How can I do this, please help.

[tomazkopac]

Ur the boss man! My masters degree is finishing in no time!

[Beautymovesindia]

So Sweet and clever you are. so much problems hav been solved for me.

[manishadevi]

very clever, excel must be surprised :)

[Robert_]

Nice solution! I've used a helper column with alpha and numeric characters then Paste Special but basically the same principle.

[sarababiker]

Perfect it worked like a charm ❤ thank u very much

[anatoliilipatkin]

Thank you, Sir! Very consice and helpful 🙏🙏

[BhavinnTrivedi]

How to add the blank row after end similar names? e.g A, A, (blank row), B, (blank row), C

[yonasmisganaw]

i really enjoyed this video of your and thanks for that yet i have questions what if the number of row is in group and i need one blank between each group ?

[zbsthic]

I need to do this, the second step is to transfer cells from another column into the empty cells. PLEASE HELP

[roywilson]

Nice solution to the problem. I just hope never to see a dataset with every alternate row as a blank though I am sure someone will use this trick to make their data look "pretty" and "nicely spaced" :D

[qwgkcul]

How to copy the row size format in other rows Sir ?

[poetsdeaddiary]

I need to insert a row after each 10000 entries, i m in logistics, so i have to do this every day, what i do is first put number on the right side then copy paste 1 to 10000, upto the last data, then search for 10000, then select the entire row below 10000 by control shift space, then control shift+ for adding row, then again do this for the next 10000 entries, for 3 to 4 lakh load i have to do this same process for 30 to 40 times, help me with this please

[asmarabadar]

okay I understood it!
But I want to add 6 black rows how to do that?

[playlearn-kidsgamestv]

but smallest to largest, this order not showing in sort

[Sandeepkol]

Hello, please advise how to insert 2 blank rows after each row having name of companies from cell A1 to A30