Adding blank row every other row to spreadsheet

[Dubaway-329]

Can anyone advise how to set up a spreadsheet so that multiple rows of information can be pasted into the spreadsheet leaving every other row blank?  Ideally I would also like to have the blank row below each filled line stay grouped to the line directly above.  Thank you in advance for any help available.

[#2]

Hi @Dubaway-329 - I found 2 methods that are pretty simple:

Here's an interesting way to paste content with a space in between using filters: https://www.extendoffice.com/documents/excel/3727-excel-paste-in-alternate-rows.html

In this method:

• Open a blank spreadsheet
• In column A, alternate 0 & 1 (or whatever numbers you choose, just 2 different numbers) down as far as you'll have data
• Click on Data > Filter or ctrl + shift + L to add filtering
• Filter to display just 1 number, either 0 or 1
• Paste your content starting in cell B1
• Remove the filter to show all numbers in column A
• You can just hide column A in case you need to add or change anything later on

And here's a similar way that doesn't require filters: https://uhasct.com/insert-an-empty-row-between-each-row-of-data-in-excel/

In this method:

• Insert a column to the left of your data
• Number the rows (just start with 1, 2, 3 then drag down the column to auto-fill the rest of the way down your data so if you had 150 rows, you'd number from 1-150)
• Copy the numbers (i.e. 1-150) and paste them at the bottom of your previous list (i.e. starting at A151 & down)
• Sort by column A so you'll have 2 of each number in ascending order, 1 row with your data, followed by 1 row that's blank
• You can just hide column A in case you need to add or change anything later on

I hope these options help you accomplish what you're trying to do!

[#3]

Sally.  Thank you very much for taking the time to help me with this.  I tried the 2nd method and it worked great.  Going to try the 1st next as there is another advantage to this for my specific need.

Much appreciated!!

---

@sally365 wrote:

Hi @Dubaway-329 - I found 2 methods that are pretty simple:

Here's an interesting way to paste content with a space in between using filters: https://www.extendoffice.com/documents/excel/3727-excel-paste-in-alternate-rows.html

In this method:

• Open a blank spreadsheet
• In column A, alternate 0 & 1 (or whatever numbers you choose, just 2 different numbers) down as far as you'll have data
• Click on Data > Filter or ctrl + shift + L to add filtering
• Filter to display just 1 number, either 0 or 1
• Paste your content starting in cell B1
• Remove the filter to show all numbers in column A
• You can just hide column A in case you need to add or change anything later on

And here's a similar way that doesn't require filters: https://uhasct.com/insert-an-empty-row-between-each-row-of-data-in-excel/

In this method:

• Insert a column to the left of your data
• Number the rows (just start with 1, 2, 3 then drag down the column to auto-fill the rest of the way down your data so if you had 150 rows, you'd number from 1-150)
• Copy the numbers (i.e. 1-150) and paste them at the bottom of your previous list (i.e. starting at A151 & down)
• Sort by column A so you'll have 2 of each number in ascending order, 1 row with your data, followed by 1 row that's blank
• You can just hide column A in case you need to add or change anything later on

I hope these options help you accomplish what you're trying to do!

---

[#4]

Thank you for the hint to add blank lines every other row.

Used the second method.

@sally365