Open the Excel table to be edited. Now it is necessary 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.

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 ...14 in column B. The specific number entered is determined by the content of the menu text, that is, the number of lines that need to be inserted into blank lines.

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

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

Select cells B2 to B 15. As shown in the figure. Click Start-Sort and Filter-Ascending. As shown in the figure.

In the pop-up Sort Reminder dialog box, the default value is to expand the selected area, keep the default value, and click Sort. The final display result is shown in Figure 2 below. Is there a blank line inserted under each row in the left column?

Playing Year Animals Together in the Spring Festival-Baidu Experience /activity/festival20 17