| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert Multiple Rows
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Critzy" wrote in message ... It worked! Thanks so much! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you insert rows into multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
| Insert Multiple Rows | Excel Discussion (Misc queries) | |||
| Insert Rows between the existing rows | Excel Discussion (Misc queries) | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
Linear Mode
