Home

Adding blank row every other row to spreadsheet

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

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!

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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies