For those who have just learned the Excel software, it may be a little difficult to insert rows every other row in batches, so what should we do? The following is the specific operation content of Excel batch inserting every other row shared by the editor. Friends in need don’t miss it!

Open the Excel table you want to edit. Now adjust the layout of the recipe text and insert a blank line every other line of the recipe content in the text. Move the cursor into B2.

Position the cursor in cell B2 and enter 1. Move the cursor to the lower right corner of cell B2, press the crtl key, pull down the list, and enter 1, 2, 3...14 in column B. The specific numbers entered are based on the content of the recipe text, that is, the number of rows that need to be inserted into blank rows. , to decide.

Move the cursor to cell B15. Continue to complete the auxiliary columns. Enter 1.5. Move the cursor to the lower right corner of cell B15, press the crtl key, pull down the list, and enter 1.5, 2.5, 3.5...13.5 in column B in sequence.

ps: The specific input numbers are in an arithmetic sequence with (B2:B15).

Select cells B2 to B15. As shown in the picture. Click Start - Sort & Filter - Ascending Sort.

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 the figure. Is there a blank row inserted below each row in the left column?

The above explains the specific operation process of inserting rows every other row in Excel. I hope friends in need can learn it.