Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 Add-ins / 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |