Insert Multiple Rows

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

Guest

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.
 
G

Guest

Hey, Max! You forgot to give me credit! for that trick (from my book "This
isn't Excel, it's Magic!"! :)
Bob Umlas
 
G

Guest

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 after every row of data in XL? 5
Insert Rows between the existing rows 4
Inserting rows using a list of numbers 3
How do i insert blank rows between data that is thousands of rows 5
Deleting Blank Rows. 3
Inserting blank rows in Excell 6
How do I insert rows between sorted data 2
Inserting Multiple Rows 4

Top