Home 
Search 
Today's Posts 
#1




How do i insert blank rows between data that is thousands of rows
I want to insert a blank row between each line of data that I have in the
quickest way possible. My spreadsheet is 12 000 rows long and want to do this as quickly as possible. I know how to insert a row wherever I want but is there a quick way, maybe a function I could use, that will insert a blank row inbetween each row of data I have? Please email me on many thanks Paul 
#2




How do i insert blank rows between data that is thousands of rows
One way in this post... http://tinyurl.com/yupz9w  Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Addins / Excel Programming) "paul.eatwell" wrote in message I want to insert a blank row between each line of data that I have in the quickest way possible. My spreadsheet is 12 000 rows long and want to do this as quickly as possible. I know how to insert a row wherever I want but is there a quick way, maybe a function I could use, that will insert a blank row inbetween each row of data I have? Please email me on... many thanks Paul 
#3




How do i insert blank rows between data that is thousands of rows
Edit this simple macro:
Sub RowInsert() For X = 2 To 12000 Rows(X).Select Selection.Insert Shift:=xlDown X = X + 1 Next X End Sub 
#4




How do i insert blank rows between data that is thousands of rows
You have been given a couple of methods but I have a question.
Why do you want the blank row? A blank row between every row will mess up sorting, filtering, copying a nd probably some other functions. If for viewing purposes only, just select all the rows and double the row height. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 08:30:00 0800, paul.eatwell wrote: I want to insert a blank row between each line of data that I have in the quickest way possible. My spreadsheet is 12 000 rows long and want to do this as quickly as possible. I know how to insert a row wherever I want but is there a quick way, maybe a function I could use, that will insert a blank row inbetween each row of data I have? Please email me on many thanks Paul 
#5




How do i insert blank rows between data that is thousands of r
what would the formula be if I wanted to insert 2 blank rows after each
existing data row? "HKaplan" wrote: Edit this simple macro: Sub RowInsert() For X = 2 To 12000 Rows(X).Select Selection.Insert Shift:=xlDown X = X + 1 Next X End Sub 
#6




How do i insert blank rows between data that is thousands of r
Sub InsertRows()
Application.ScreenUpdating = False Dim numRows As Integer Dim r As Long Dim X As Long numRows = 2 'adjust for rows to insert X = Cells(Rows.Count, 1).End(xlUp).Row 'last row in column A For r = X To 1 Step 1 ActiveSheet.Rows(r + 1).Resize(numRows).EntireRow.Insert Next r Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Mon, 14 Apr 2008 11:51:00 0700, CJ wrote: what would the formula be if I wanted to insert 2 blank rows after each existing data row? "HKaplan" wrote: Edit this simple macro: Sub RowInsert() For X = 2 To 12000 Rows(X).Select Selection.Insert Shift:=xlDown X = X + 1 Next X End Sub 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Copy rows of data (eliminating blank rows) from fixed layout  Excel Discussion (Misc queries)  
How do I insert blank rows between rows in completed worksheet?  Excel Discussion (Misc queries)  
How do I insert alternating blank rows in a list of data?  Excel Worksheet Functions  
How do I create a Macro to sort data and insert blank rows & subto  Excel Worksheet Functions  
Insert blank rows repeatedly between every data row in Excel  Excel Discussion (Misc queries) 