Sometimes it is necessary to insert a blank line under each line in order to look good in typesetting or avoid confusion in positioning when dealing with a large amount of data. You can add data manually when there is little data. What should I do if I need to insert a blank line when I encounter a lot of data? Here is how to use the convenient and quick method.

batch processing

Every other line

insert

blank line

problem

The first step is to open the one to be edited.

Excel spreadsheet

. Now we need to adjust the menu.

main body

When typesetting, the content in the text menu is every other

A group traveling together

Insert a blank line. will

cursor

Move to B2.

Step 2, position the cursor at B2.

cell

, enter 1. Move the cursor to the lower right corner of cell B2, press crtl, and drop down the list. Enter 1, 2, 3... 14 in column B in turn.

figure

It 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 specific number entered is the same as (B2: B 15).

arithmetic series

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,

System default value

Yes, expand the selected area, leave the default values, and then click Sort. The final display result is shown in Figure 2 below. Is it every line in the left column?

A lower position or level

An empty line was inserted.