How do I insert blank rows between rows in completed worksheet?

G

Guest

I have a large data worksheet, over 5,000 rows. I want to insert a blank row
between each row, I have done it manually, right click and insert, but when I
transfer updated data to a new workbook, I have to start all over. Can I
format a blank worksheet to do what I want and then copy and paste? Can I
format the existing worksheet permanantly? How...please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort with blank rows between data rows 1
Need Macro- Insert rows based on dates and copy info from that row 1
INSERTING ROWS 5
Insert blank rows 2
insert blank rows 2
Inserting blank rows 3
Inserting blank rows in Excell 6
Insert Multiple Blank Rows 3

Top