inserting a row every other row

[Mark CU]

I have a list of 500, each in a row. I want to insert a row above each row, so it would be a data row, a blank row, a data row, a blank row...

Thank you

[Mark W.]

Insert a blank column to the left of your existing data. In this column number your rows 1-500. Copy these 1-500 values and paste them directly beneath the copied values. Sort your rows in ascending order based on the 1-500 values. Delete the inserted column.

[Mark CU]

Thank you great idea,

but I need them ( the rows ) in the alphabetic order there are in now.

what would you suggest ?

thanks agian

[Mark CU]

omg,,how silly of me....it worked great

THANK YOU ...

[Nimrod]

Macro Solution for you

Sub AddSpace()
    For Rw = 1 To 1000 Step 2
        Rows(Rw & ":" & Rw).Insert Shift:=xlDown
    Next
End Sub