ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert blank rows between rows in completed worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/116239-how-do-i-insert-blank-rows-between-rows-completed-worksheet.html)

bblue1978

How do I insert blank rows between rows in completed worksheet?
 
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.

CLR

How do I insert blank rows between rows in completed worksheet?
 
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do it for you...........

Vaya con Dios,
Chuck, CABGx3



"bblue1978" wrote:

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.



All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com