If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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 
Ads 
#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 >> 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Copy rows of data (eliminating blank rows) from fixed layout  Sweepea  Excel Discussion (Misc queries)  1  March 14th 07 12:05 AM 
How do I insert blank rows between rows in completed worksheet?  bblue1978  Excel Discussion (Misc queries)  1  October 26th 06 07:02 PM 
How do I insert alternating blank rows in a list of data?  curiouscat  Excel Worksheet Functions  5  September 18th 06 11:09 PM 
How do I create a Macro to sort data and insert blank rows & subto  karinmpfa  Excel Worksheet Functions  2  April 25th 06 09:57 PM 
Insert blank rows repeatedly between every data row in Excel  Cool  Excel Discussion (Misc queries)  2  January 9th 06 01:10 PM 