What are the insertion techniques in excel?

php editor Apple has carefully compiled Excel insertion skills for everyone, including inserting charts, formulas, pivot tables and other practical skills. By mastering these skills, you can improve work efficiency and make Excel applications more flexible and convenient. Whether you are a beginner or an experienced user, you can benefit from it, come and learn!

Insert two rows every other row:

1. Create an auxiliary column and generate a sequence starting from 1

2. Copy again Paste this sequence twice below

3. Select any cell in this column, click [Sort and Filter] in the [Home] tab, and select ascending order.

#4. This completes the insertion of two blank rows every other row. For the remaining header part, refer to steps 4, 5, and 6 in the above example.

Insert a row after multiple rows:

In the table above, we need to insert a blank row in the middle of each department, and the number of each department is not Same, how to insert blank rows in batches?

1. Enter the formula in cell G3: =IF(A2=A3,"",1), and then pull down or double-click to fill in the formula

2. Press the Ctrl G key (or F5 key) to bring up the positioning window, click [Positioning Conditions], select [Formula], check [Number], remove other check boxes, and finally click [Confirm] Return to the workspace

3. After the previous step, the cell showing the number 1 is selected. Right-click the selected cell and select [Insert]. Select [Entire Row], and finally click [OK], so that a blank row is inserted between each department.

Insert a row after multiple rows:

1. Insert a column after the department column, and copy the content of the department column to the next row of this column, as shown in the figure Shown

2. Select the contents of these two columns, press Ctrl G key (F5 key) to bring up the positioning window, click [Positioning Conditions], and select [Row Content Difference Unit] Cell], and finally click [OK] to return to the workspace

3. Right-click the selected cell, select [Insert], select [Whole Row], and finally click [OK] ], similarly insert a blank row in the middle of each department, and finally delete column B.

The above is the detailed content of What are the insertion techniques in excel?. For more information, please follow other related articles on the PHP Chinese website!