Home>Article>Software Tutorial> How to operate a sorted table in EXCEL and add multiple blank rows between different names

How to operate a sorted table in EXCEL and add multiple blank rows between different names

PHPz
PHPz forward
2024-01-17 09:30:16 1306browse

How to operate a sorted table in EXCEL and add multiple blank rows between different names

How to add multiple blank rows between different names in a column in a table after EXCEL sorting If

is less, right-click the line number and select Insert. A row will be inserted in front. Repeat several times.

If there are more, use vba programming.

Create a macro. Copy this code, change "D" to the letter of the column you want to determine duplicates, and then run it.

For i = ActiveSheet.UsedRange.Cells.Rows.Count To 2 Step -1

If Len(Trim(ActiveSheet.Cells(i, "D").Value)) = 0 Then

Else

If Trim(ActiveSheet.Cells(i - 1, "D").Value) Trim(ActiveSheet.Cells(i, "D").Value) Then

Rows(i).Insert

End If

End If

Next

Each word in an excel cell occupies one line

Use VBA to design a command button and enter the following code:

Private Sub CommandButton1_Click()

Range("C:D").ClearContents

k = 1

For Each rag In Range("A:A")

If rag.Value = """ Then Exit For

For j = 1 To Len(Trim(rag.Offset(, 1)))

Range("C" & k) = rag.Value

Range("D"& k) = Mid(Trim(rag.Offset(, 1).Value), j, 1)

k = k 1

Next j

Next

End Sub

The above is the detailed content of How to operate a sorted table in EXCEL and add multiple blank rows between different names. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:docexcel.net. If there is any infringement, please contact admin@php.cn delete