Current location - Recipe Complete Network - Complete cookbook - How to insert a row every other row in batch in excel
How to insert a row every other row in batch in excel
As shown in the figure, before each line of the table shown in the figure, insert the contents of the first line title line respectively.

1, insert 9 blank lines between 1 and 2 lines.

2. Fill the first line in line 2~ 10.

3. Fill in "1" and "3" in cells H 1 and H2 respectively.

4. Select cells H 1 and H2, and move the mouse to the lower right corner of H2. When the cursor changes to a black cross, hold down the left mouse button and drag it down to H 10.

5. Fill the cell H 1 1~H20...20 with 2, 4 and 6 as above.

6. Cancel the multi-selection of H 1 1~H22, and position the cursor in a cell of H 1~H20. Click Sort in Ascending Order in the formatting toolbar.

7. Complete the task. Just delete the H column.