Auto insert of blank lines

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

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.
 
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.
 
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
 
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

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
 
Back
Top