Adding blank row every other row to spreadsheet

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!

---

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

Used the second method.

sally365