Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 17th 08, 04:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1
Default 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   Report Post  
Old January 17th 08, 05:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,290
Default 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   Report Post  
Old January 17th 08, 05:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 80
Default 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   Report Post  
Old January 17th 08, 09:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default 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   Report Post  
Old April 14th 08, 07:51 PM posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 102
Default 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   Report Post  
Old April 14th 08, 10:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 13th 07 11:05 PM
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 12:10 PM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017