How to add a blank row after each existing row?
 

I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

You can do that by sorting a helper column.
In a adjoining blank column, auto fill it with numbers from 1 to 200.
Directly below the new data, autofill another 200 rows with numbers from
1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down)
Sort by the new column, clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Stephanie"
wrote in message
I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

Here's a VBA solution (Quicky)..
Presently assumes Your data (rows) are among others also in Column A
Paste this in a Standard module and run it
Back up your data before doing so to prevent Unforeseen "PROBLEMS"!!

Sub InsertBlkRows()
Dim lr As Long
Dim fr As Long
Dim i As Integer
fr = InputBox("My First Row is Excel Numbered Row - What?")
lr = Range("A65536").End(xlUp).Row
For i = lr To (fr + 1) Step -1
Range("A" & i).EntireRow.Insert
Next i
End Sub

HTH,
Jim May


"Jim Cone" wrote in message
:

You can do that by sorting a helper column.
In a adjoining blank column, auto fill it with numbers from 1 to 200.
Directly below the new data, autofill another 200 rows with numbers from
1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down)
Sort by the new column, clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Stephanie"
wrote in message
I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

Do you need a blank row?

This can cause problems later when filtering or sorting or autofilling formulas.

Maybe just double the row heights if for viewing appearance only.


Gord Dibben MS Excel MVP

On Sat, 19 Aug 2006 06:48:01 -0700, Stephanie
wrote:

I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

Stephanie;

Even though I provided a solution
Gord is providing some good advise;

Jim

"Gord Dibben" <gorddibbATshawDOTca wrote in message
:

Do you need a blank row?

This can cause problems later when filtering or sorting or autofilling formulas.

Maybe just double the row heights if for viewing appearance only.


Gord Dibben MS Excel MVP

On Sat, 19 Aug 2006 06:48:01 -0700, Stephanie
wrote:

I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

Vow!

Your solution is really wise and mathematical. Wonderful!

Cheers.

Jaleel



"Jim Cone" wrote:

You can do that by sorting a helper column.
In a adjoining blank column, auto fill it with numbers from 1 to 200.
Directly below the new data, autofill another 200 rows with numbers from
1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down)
Sort by the new column, clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Stephanie"
wrote in message
I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...

How to add a blank row after each existing row?
 

Jim - amazing solution. Thanks!

"Jim Cone" wrote:

You can do that by sorting a helper column.
In a adjoining blank column, auto fill it with numbers from 1 to 200.
Directly below the new data, autofill another 200 rows with numbers from
1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down)
Sort by the new column, clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Stephanie"
wrote in message
I have a set of data (200 rows /8 columns). I need to insert a blank row
after each row of data...