Step 1: Open the excel table to edit. Now we need to adjust the typesetting of the menu text, and insert a blank line every other line in the menu content of the text. Move the cursor to b2.

Step 2: Position the cursor in cell b2 and enter 1. Move the cursor to the lower right corner of b2 cell, press crtl key, drop down the list, and enter 1, 2, 3...b column 14. The specific number entered is determined by the content of the menu text, that is, the number of blank lines to be inserted.

Step 3, move the cursor to cell b 15. Continue to complete the sidebar. Enter 1.5. Move the cursor to the lower right corner of cell b 15, press crtl to drop down the list, and then enter 1.5, 2.5, 3.5... 13.5 in column B in turn.

Ps: The number entered is arithmetic progression with (B2: B 15).

Step 4: Select cells b2 to b 15. As shown in the figure. Click Start-Sort and Filter-Ascending. As shown in the figure.

Step 5: In the pop-up "Sorting Reminder" dialog box, expand the selected area by default, keep the default value, and click Sort. The final display result is shown in Figure 2 below. Insert a blank line under each line in the left column?