Feb 18 2019 08:37 AM
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.
Feb 20 2019 07:48 AM
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:
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:
I hope these options help you accomplish what you're trying to do!
Feb 20 2019 05:12 PM
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!
Jan 19 2022 06:33 PM