Insert Multiple Rows
 

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!

Insert Multiple Rows
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote:
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!

Insert Multiple Rows
 

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

"Max" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote:
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!

Insert Multiple Rows
 

It worked! Thanks so much!

"Max" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote:
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!

Insert Multiple Rows
 

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote in message
...
It worked! Thanks so much!

Insert Multiple Rows
 

Sorry about that, Bob <g !
(I don't have a copy of your book)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Umlas, Excel MVP" wrote in
message ...
Hey, Max! You forgot to give me credit! for that trick (from my book "This
isn't Excel, it's Magic!"! :-)
Bob Umlas