Adding blank row every other row to spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-352633%22%20slang%3D%22en-US%22%3EAdding%20blank%20row%20every%20other%20row%20to%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352633%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20advise%20how%20to%20set%20up%20a%20spreadsheet%20so%20that%20multiple%20rows%20of%20information%20can%20be%20pasted%20into%20the%20spreadsheet%20leaving%20every%20other%20row%20blank%3F%26nbsp%3B%20Ideally%20I%20would%20also%20like%20to%20have%20the%20blank%20row%20below%20each%20filled%20line%20stay%20grouped%20to%20the%20line%20directly%20above.%26nbsp%3B%20Thank%20you%20in%20advance%20for%20any%20help%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352633%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354342%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20blank%20row%20every%20other%20row%20to%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354342%22%20slang%3D%22en-US%22%3E%3CP%3ESally.%26nbsp%3B%20Thank%20you%20very%20much%20for%20taking%20the%20time%20to%20help%20me%20with%20this.%26nbsp%3B%20I%20tried%20the%202nd%20method%20and%20it%20worked%20great.%26nbsp%3B%20Going%20to%20try%20the%201st%20next%20as%20there%20is%20another%20advantage%20to%20this%20for%20my%20specific%20need.%3C%2FP%3E%3CP%3EMuch%20appreciated!!%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F287138%22%20target%3D%22_blank%22%3E%40sally365%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F286259%22%20target%3D%22_blank%22%3E%40Dubaway-329%3C%2FA%3E%26nbsp%3B-%20I%20found%202%20methods%20that%20are%20pretty%20simple%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20interesting%20way%20to%20paste%20content%20with%20a%20space%20in%20between%20using%20filters%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3727-excel-paste-in-alternate-rows.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3727-excel-paste-in-alternate-rows.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20method%3A%3C%2FP%3E%3CUL%3E%3CLI%3EOpen%20a%20blank%20spreadsheet%3C%2FLI%3E%3CLI%3EIn%20column%20A%2C%20alternate%200%20%26amp%3B%201%20(or%20whatever%20numbers%20you%20choose%2C%20just%202%20different%20numbers)%20down%20as%20far%20as%20you'll%20have%20data%3C%2FLI%3E%3CLI%3EClick%20on%20Data%20%26gt%3B%20Filter%20or%20ctrl%20%2B%20shift%20%2B%20L%20to%20add%20filtering%3C%2FLI%3E%3CLI%3EFilter%20to%20display%20just%201%20number%2C%20either%200%20or%201%3C%2FLI%3E%3CLI%3EPaste%20your%20content%20starting%20in%20cell%20B1%3C%2FLI%3E%3CLI%3ERemove%20the%20filter%20to%20show%20all%20numbers%20in%20column%20A%3C%2FLI%3E%3CLI%3EYou%20can%20just%20hide%20column%20A%20in%20case%20you%20need%20to%20add%20or%20change%20anything%20later%20on%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20here's%20a%20similar%20way%20that%20doesn't%20require%20filters%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fuhasct.com%2Finsert-an-empty-row-between-each-row-of-data-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fuhasct.com%2Finsert-an-empty-row-between-each-row-of-data-in-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20method%3A%3C%2FP%3E%3CUL%3E%3CLI%3EInsert%20a%20column%20to%20the%20left%20of%20your%20data%3C%2FLI%3E%3CLI%3ENumber%20the%20rows%20(just%20start%20with%201%2C%202%2C%203%20then%20drag%20down%20the%20column%20to%20auto-fill%20the%20rest%20of%20the%20way%20down%20your%20data%20so%20if%20you%20had%20150%20rows%2C%20you'd%20number%20from%201-150)%3C%2FLI%3E%3CLI%3ECopy%20the%20numbers%20(i.e.%201-150)%20and%20paste%20them%20at%20the%20bottom%20of%20your%20previous%20list%20(i.e.%20starting%20at%20A151%20%26amp%3B%20down)%3C%2FLI%3E%3CLI%3ESort%20by%20column%20A%20so%20you'll%20have%202%20of%20each%20number%20in%20ascending%20order%2C%201%20row%20with%20your%20data%2C%20followed%20by%201%20row%20that's%20blank%3C%2FLI%3E%3CLI%3EYou%20can%20just%20hide%20column%20A%20in%20case%20you%20need%20to%20add%20or%20change%20anything%20later%20on%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20these%20options%20help%20you%20accomplish%20what%20you're%20trying%20to%20do!%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354055%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20blank%20row%20every%20other%20row%20to%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354055%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B-ERR%3AREF-NOT-FOUND-%40Dubaway-329%26nbsp%3B-%20I%20found%202%20methods%20that%20are%20pretty%20simple%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20interesting%20way%20to%20paste%20content%20with%20a%20space%20in%20between%20using%20filters%3A%26nbsp%3B-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3727-excel-paste-in-alternate-rows.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3727-excel-paste-in-alternate-rows.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20method%3A%3C%2FP%3E%3CUL%3E%3CLI%3EOpen%20a%20blank%20spreadsheet%3C%2FLI%3E%3CLI%3EIn%20column%20A%2C%20alternate%200%20%26amp%3B%201%20(or%20whatever%20numbers%20you%20choose%2C%20just%202%20different%20numbers)%20down%20as%20far%20as%20you'll%20have%20data%3C%2FLI%3E%3CLI%3EClick%20on%20Data%20%26gt%3B%20Filter%20or%20ctrl%20%2B%20shift%20%2B%20L%20to%20add%20filtering%3C%2FLI%3E%3CLI%3EFilter%20to%20display%20just%201%20number%2C%20either%200%20or%201%3C%2FLI%3E%3CLI%3EPaste%20your%20content%20starting%20in%20cell%20B1%3C%2FLI%3E%3CLI%3ERemove%20the%20filter%20to%20show%20all%20numbers%20in%20column%20A%3C%2FLI%3E%3CLI%3EYou%20can%20just%20hide%20column%20A%20in%20case%20you%20need%20to%20add%20or%20change%20anything%20later%20on%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20here's%20a%20similar%20way%20that%20doesn't%20require%20filters%3A%26nbsp%3B-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fuhasct.com%2Finsert-an-empty-row-between-each-row-of-data-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fuhasct.com%2Finsert-an-empty-row-between-each-row-of-data-in-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20method%3A%3C%2FP%3E%3CUL%3E%3CLI%3EInsert%20a%20column%20to%20the%20left%20of%20your%20data%3C%2FLI%3E%3CLI%3ENumber%20the%20rows%20(just%20start%20with%201%2C%202%2C%203%20then%20drag%20down%20the%20column%20to%20auto-fill%20the%20rest%20of%20the%20way%20down%20your%20data%20so%20if%20you%20had%20150%20rows%2C%20you'd%20number%20from%201-150)%3C%2FLI%3E%3CLI%3ECopy%20the%20numbers%20(i.e.%201-150)%20and%20paste%20them%20at%20the%20bottom%20of%20your%20previous%20list%20(i.e.%20starting%20at%20A151%20%26amp%3B%20down)%3C%2FLI%3E%3CLI%3ESort%20by%20column%20A%20so%20you'll%20have%202%20of%20each%20number%20in%20ascending%20order%2C%201%20row%20with%20your%20data%2C%20followed%20by%201%20row%20that's%20blank%3C%2FLI%3E%3CLI%3EYou%20can%20just%20hide%20column%20A%20in%20case%20you%20need%20to%20add%20or%20change%20anything%20later%20on%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20these%20options%20help%20you%20accomplish%20what%20you're%20trying%20to%20do!%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

3 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!


 

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

Used the second method.

@sally365