Home

Adding blank row every other row to spreadsheet

Highlighted
Dubaway-329
New Contributor

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 Replies
Highlighted

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!

Highlighted

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!


 

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Loading spreadsheet with notes in cells into Teams
DaleA123 in Microsoft Teams on
0 Replies
Spreadsheets with mobile access
darciwilliams in Microsoft Teams on
5 Replies
Power Query ::: Danish (or almost)
Jørgen Koch in Localization Feedback on
4 Replies
Source Code for the demo in this video
tob-19 in Localization Feedback on
0 Replies