I will now stick in my standard reply to this request.

Inserting a row between each row of data will make it very difficult to do any
type of sorting or filtering the data.

If just for visual appearance, better to double the row heights.


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 04:59:01 -0800, snarled times
wrote:

I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.
thanks in advance.