How to batch insert blank rows at alternate rows in an Excel table - How to batch insert multiple blank rows at alternate rows in an Excel table

Faced with the dilemma of needing to insert a large number of blank rows at alternate rows in Excel tables, PHP editor Yuzai brings you a solution. This method is simple and easy to implement, and will gradually guide you to easily insert blank rows every other row, thus greatly improving your data processing efficiency. Read on for more details below to learn the specific steps and techniques so you can say goodbye to tedious data processing tasks.

Figure 1 is the style of the original table, which is a complete salary table. Figure 2 is the style we want to achieve, with two blank lines inserted between each salary slip.

This is done with the help of auxiliary columns. Insert an auxiliary column (column H in this example) on the right side of the table, and enter the numbers 1 and 2 in cells H2 and H3 of the auxiliary column respectively.

Select cells H2 and H3, find the fill handle (number) in the lower right corner of the cell, double-click with the left mouse button, and mark each row of salary data with a number.

Copy the existing label (the number in the auxiliary column in the previous step) and paste it 2 times below the existing label (in this case we want to insert 2 blank lines, so paste 2 times).

That is: there are 22 data in this example. After copying the numbers 1 to 22, paste once in the 23rd row of the auxiliary column, and then paste once in the 46th row of the auxiliary column, a total of 2 times .

After copying and pasting the label, sort the auxiliary column in ascending order.

After the sorting is completed, we find that the numbers in the original auxiliary column have become a sequence of 111, 222, 333, that is: the empty rows below are moved to the table during sorting coming. In this way, we quickly completed batch production of interlaced salary tables.

The above is the detailed content of How to batch insert blank rows at alternate rows in an Excel table - How to batch insert multiple blank rows at alternate rows in an Excel table. For more information, please follow other related articles on the PHP Chinese website!