In Excel2000 made of payroll, only the first person has a payroll bar header (such as the number, name, job salary, salary for years of experience ......), and want to be output as a payroll bar form. How to do?
Solution:
(1), assuming that the original payroll table is "Table 1", first copy "Table 1" to a new blank table, named "Table 2", delete "Table 2". Delete "Table 2" in the redundant rows, so that the head of the payroll is located in the first line, the employee's salary data in order immediately after the head of the line.
(2), in "Table 2" wage data in the latter column H, add "labeling" column, in order to fill in 1, 2, 3 ... and other steps down to the number of sequences of 1.
(3), select "Table 2" under the payroll header (payroll header is not selected) the second to the last line, right-click: Insert, Table 2, there will be a number of new blank lines, the header data will be filled into these new blank lines (method: select A1: G1, right-click "Copy") ", and then select all the new blank lines, right-click "Paste" can be used, can also be used to drag and drop filling method). And then in its "labeling" column filled with 1.5, 2.5, 3.5 .... And so on the number of sequences with a step size of 1. The results of the operation are shown as follows:
(4), again selected "Table 2" line 2 to the last line, click on the menu: Data - Sort - according to the "labeling" column (incremental) sorting, click OK. Then select H "labeled" column, right-click: "Hide" or "Delete", so that the basic production of payroll is complete.
(5), the completion of the production of payroll cut can be distributed to colleagues. If you feel that this form is too crowded, you can also use a similar method to insert a blank line between each person.