Insert Multiple Rows

C

Critzy

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

Max

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

Bob Umlas, Excel MVP

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

Critzy

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