(1) Insert the auxiliary column? (2) Classification

Making method of changing payroll to payroll

Step one:? Open the excel payroll we want to process.

Step 2: fill in the serial number in the column behind the payroll (hint: in? G2 After filling in 1, put the mouse in the lower left corner of G 1 and a+will appear. Click+auto-fill twice) and then copy it twice.

Step 3: Copy the header 6 times.

The fourth step: sorting, the main keywords are in column G (the column we add serial number), and arranged in ascending order; The secondary keywords are listed in column F (that is, the column that should be paid), and click OK.