Make payroll tips in Excel2010 tables

① first of all, in the EXCEL2010 to create a worksheet named Payroll table, as shown in the figure, make the payroll head, by the number of people pull the copy, and then in the Excel worksheet first column number, press 1, 3, 5, 7 ... Ordinal number. Here is a little trick, first manually input 1, 3, 5, and then select all three EXCEL2010 cells, down to the end, EXCEL2010 will automatically fill the odd number, so that the salary table head is done.

② then make a worksheet called a person in the EXCEL2010, fill in the person's name and the elements in the payroll, and then use the same EXCEL2010 for the contents of the table.

③ Finally, copy the People table to the bottom of the Payroll header content in EXCEL2010, then select the ordinal column, use the EXCEL2010 sort function, select from small to large, select the extended selection item in the sort reminder, EXCEL2010 press 1, 2, 3, 4 ... In order, EXCEL2010 's work on making payroll is complete.