Inserting multiple blank rows in Excel

  John B 12:02 10 Jan 06

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'?



  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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…