Add insert row on every other record

[mttorpy]

I am using Excel 2003, I have lots of data I need to autofill but need to make room for it first.

I would like to inset a row on every other record so basiclly a blank row on every other line.

Any shortcuts to doing this, very new to excel

Thanks

 

[Dreamboat]

This is a BAD idea if you want to continue using Excel's greatest features.

Why do you want to do this?
Why not just increase the row height on your records?

Anne Troy
VBA Coders, please help:

http://www.vbaexpress.com/kb

 

[BenRowe]

Since you imply you need blank rows so you can autofill them (I assume from data in row above), one way of adding in blank rows is:
(1) in first cell of a column not presently being used, type the number 1 and then select this cell and rest of column (all current rows in worksheet).
(2) go to edit - fill - series; change step value to 2; click ok
(3) you should now see 1, 3, 5, etc. in this column.
(4) in cell in first row beyond all current rows, type the number 2 and then select this cell and the same number of cells in this column to match the rows numbered 1, 3, 5, etc.
(5) repeat step 2; these rows will be numbered 2, 4, 6, etc.
(6) now sort your worksheet by this column
(7) delete this column

 

[BenRowe]

I just discovered that while holding down the ctrl key and then selecting each row one by one and then select Insert - Row it puts in a blank row between each row. However, if you have a lot of rows this could be time consuming. So way I outlined above, although a bit more complicated, might actually be quicker.

 

[Dreamboat]

mttorpy:

My most humble apologies.
I did not RTFQ!!

Please forgive me.

Anne Troy
Supercharge your Office Applications:

http://www.vbaexpress.com