How to batch insert rows every other row in Excel

Open the Excel table to be edited. Now you need to adjust the layout of the recipe text and insert a blank line every other line in the recipe content. 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 where blank rows need to be inserted. , 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 number entered is consistent with (B2:B15) Arithmetic sequence.

Select cells B2 to B15. as the picture shows. Click Start - Sort & Filter - Ascending Sort.

In the [Sort Reminder] dialog box that pops up, 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 row inserted below each row in the left column?

The above is the detailed content of How to batch insert rows every other row in Excel. For more information, please follow other related articles on the PHP Chinese website!