IS THERE A WAY TO INSERT MORE THAN ONE ROW AT A TIME IN A WORKSHE
 

Is there a way of inserting multiple blank rows in between multiple rows of
data at once. So that the rows of data have identicalal rows of spacing.

IS THERE A WAY TO INSERT MORE THAN ONE ROW AT A TIME IN A WORKSHE
 

1 - in an unused column, enter sequential #s for the current data,
(1,2,...50)
2 - Copy the whole range of #s
3 - If you want to insert x blank rows, paste the numbers x times below the
current data. So if you want to insert 2 blank rows, in cell J51 (for
example) paste the values, then again in cell J101 paste the values. You'd
now have 1,2,...,50,1,2,...,50,1,2,...50. That is, 3 sets of #s from 1-50.
(If you had 200 rows you'd have 3 sets of #s from 1 to 200).
4 - select all your data, and sort by this column of numbers (J in this
example). Clear column J and you're done!
From my book, This isn't Excel, it's Magic, page 111.
http://www.iil.com/iil/excelmagic.
Bob Umlas

"Chris" wrote in message
...
Is there a way of inserting multiple blank rows in between multiple rows
of
data at once. So that the rows of data have identicalal rows of spacing.