Inserting multiple blank rows in Excel

  John B 12:02 10 Jan 06
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 06

click here

It came from here: click here

  John B 12:32 10 Jan 06

I copied and pasted the code and off it went!

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac