Insert Multiple Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a spreadsheet that has 1000 rows of data. I want to insert
a blank row in between each row of data. Is there a way to do this without
manually right clicking and inserting a row after each one?

Please help!
 
Assume source data within A1:A1000
Fill B1:B1000 with the number series: 1, 2, 3, ... 1000
Copy B1:B1000, paste into B1001:B2000
Then just select cols A and B, sort by col B > Ascending
Col A is now transformed as desired. Delete col B to clean up.
 
Hey, Max! You forgot to give me credit! for that trick (from my book "This
isn't Excel, it's Magic!"! :-)
Bob Umlas
 
It worked! Thanks so much!

Max said:
Assume source data within A1:A1000
Fill B1:B1000 with the number series: 1, 2, 3, ... 1000
Copy B1:B1000, paste into B1001:B2000
Then just select cols A and B, sort by col B > Ascending
Col A is now transformed as desired. Delete col B to clean up.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert a row between every line in my spreadsheet? 3
How do I insert a row after every row of data in XL? 5
Inserting blank rows 3
How do i insert blank rows between data that is thousands of rows 5
Insert Blank Row with data match change 1
Inserting rows using a list of numbers 3
Inserting blank rows in Excell 6
Insert Multiple Blank Rows 3

Back
Top