Excel Bulk Insert Table Head Tutorial

Scenario: Here, for example, make a pay line. Each month the human resources department needs to calculate the salary details of each employee as shown in "Figure I", then add the table head in bulk, make the style as shown in "Figure II", then print it into the paper tailoring, or send the email to each person's electronic version of salary details.

　　Operation Steps

1, select the table header contents of the cell, right-click the selected area, select the Copy command.

2. Calculate the total number of table headers (11-2 or 9 lines), and copy the corresponding number of rows below.

3, as shown in the following figure, the corresponding wage line and header line in accordance with the rules of the following figure in the rear number.

4. In the numbered column, right-click a cell and select sort → ascending.

5, delete the numbered L column, the production of the wage bar completed.