编写如下宏,可以做到瞬间完成。 Sub gz() Dim Irow As Integer, Icol As Integer Application.ScreenUpdating = False Irow = [A1].CurrentRegion.Rows.Count a = (Irow - 1) * 2 Icol = [A1].CurrentRegion.Columns.Count For i = 2 To a Step 2 If Cells(i, 1) <> "" And Cells(i + 1, 1) <> "" Then Rows(i + 1).Insert End If If Cells(i, 1) <> "" And Cells(i + 1, 1) = "" Then Range(Cells(1, 1), Cells(1, Icol)).Copy Cells(i + 1, 1) End If Next i Range("A1").Select Application.ScreenUpdating = True End Sub