Hello!

I have a worksheet with four data columns A,B,C,D starting in row 2. I want to add between every row, exactly 11 blank rows. So if we have:

A B C D

1 5 3 4
2 7 6 3
3 9 1 3
the end result should be:

A B C D

1 5 3 4











2 7 6 3












3 9 1 3
Do I necessarily need a macro for this? Or is there another quick and creative way to achieve this result?

Thank you for your time!

Regards,

excelactuary