Excel- any experts

[christywhisty]

I have a spread of over 100 rows. I need to insert a row between each row, is there a quick way of doing it, without having to insert each row seperately?

Can you do some sort of weirdo cut & paste with empty cells from bottom of page?

Yes.

Add a new COLUMN put a 2 in the top cellll,4 underneath, then a 6 and fill down to the bottom of the hundred rows.

Under this in the same column put a 1, then a 3, then a 5. Fill down for the next 100 rows.

Then sort this column.

Then delete the column!

Thanks! I went for Nuttygirl's option. But thanks Littlelapin and Noodlestroodle for your replies as well