Home  >  Article  >  Software Tutorial  >  How to batch insert rows every other row in Excel

How to batch insert rows every other row in Excel

WBOY
WBOYforward
2024-04-17 13:43:081115browse

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.

How to batch insert rows every other row in Excel

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.

How to batch insert rows every other row in Excel

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.

How to batch insert rows every other row in Excel

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

How to batch insert rows every other row in Excel

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?

How to batch insert rows every other row in Excel

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete