INSERTING ROWS

[snarled times]

I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.

 

[Max]

This might suffice ..
Assume data is in rows 1 - 10 in cols A to C
Insert a new col A, fill A1:A10 with serials: 1,2,3... 10
Copy A1:A10 n paste the same serial nos into A11:A20
Select cols A to D, Click Data > Sort > Sort by Col A (ascending) > OK
Clean up, delete col A

 

[Don Guillett]

for i=cells(rows.count,"a").end(xlup).row to 2 step-1
rows(i).insert
next

 

[snarled times]

Don,
I am not this advanced, can you explain how I would do this? thanks

 

[Don Guillett]

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gord Dibben]

I will now stick in my standard reply to this request.

Inserting a row between each row of data will make it very difficult to do any
type of sorting or filtering the data.

If just for visual appearance, better to double the row heights.


Gord Dibben MS Excel MVP