If the inserted rows are just for readability/appearance, you can select a whack
of rows and double their height at one go.

Otherwise, go with Chip's code.


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 07:04:02 -0700, Greg wrote:

Is it possible to insert a row in every other line all at ounce in an excel
document?
In otherwords I have an Excel document that I have to insert a new row at
every other line and would like a way to do it all in one shot instead of
manually right-clicking each line and inserting a row.

If possible how can this be done

Thanks in advance.
Greg