Inserting multiple blank rows in Excel

  John B 12:02 10 Jan 2006
Locked

I have a spreadsheet with about 1000 rows of data. I would like to insert a blank row beneath each of the existing rows (so the sheet would have a row of existing data then a blank row and so on).

Is there a quick way of doing this please or do I have to insert each black row 'manually'?

Thanks

John

  John B 12:22 10 Jan 2006

click here

It came from here: click here

  John B 12:32 10 Jan 2006

I copied and pasted the code and off it went!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?