Auto insert of blank lines
 

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.

Auto insert of blank lines
 

One way ..
Assume you have 10 data lines in rows 1 to 10
Insert a new col A, fill the series:1,2,3.. 10 in A1:A10.
Copy A1:A10, paste into A11:A20
Then select the entire sheet, sort by col A ascending.
This gives you the required results - blank lines insertion between each
data line.
Delete col A to clean up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robert" wrote:
After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.

Auto insert of blank lines
 

Rather than inserting a blank row between rows of data maybe just double the row
heights of the existing rows for appearance.

Blank rows will make it very difficult work with your data when you need to sort
or filter or copy/paste.


Gord Dibben MS Excel MVP


On Wed, 28 Nov 2007 06:54:01 -0800, Robert
wrote:

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.

Auto insert of blank lines
 

Thanks I will try this.

"Robert" wrote:

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.

Auto insert of blank lines
 

I thought of this, the problem though that I have is that all row are not the
same size, unless you know how to double the size when the rows might be
different sizes.

Thanks
"Robert" wrote:

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.

Auto insert of blank lines
 

Robert

Sub foo()
Dim c As Range
For Each c In Selection
c.RowHeight = c.RowHeight * 2 'or 1.5 or whatever you choose
Next c
End Sub

Believe me.....you will have fewer problems if you don't insert blank rows.


Gord

On Wed, 28 Nov 2007 12:10:02 -0800, Robert
wrote:

I thought of this, the problem though that I have is that all row are not the
same size, unless you know how to double the size when the rows might be
different sizes.

Thanks
"Robert" wrote:

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with. I have been doing it
manually, but it takes a long time on big spreadsheets. Is there a way to
have excel insert a blank line after each data line automatically? I am
using excel 2003. Thanks for any help.