Excel2010 is a good software that has attracted many people to install it. Next, the editor will explain the operation process of making salary slips in Excel 2010. I believe it will definitely help you.

① First, create a worksheet named Salary Header in Excel 2010. As shown in the figure, make the salary header, pull down and copy according to the number of people, then number in the first column of the EXCEL worksheet, press 1, Sequential numbers of 3, 5, 7... Here is a little trick: first manually enter 1, 3, and 5, then select all three EXCEL 2010 cells, pull down to the bottom, and Excel 2010 will automatically fill in odd numbers. In this way, the salary header is ready.

​ ​ ②Create a worksheet named personnel in excel 2010, fill in the personnel names and elements of the salary table, and then also use excel 2010 to number the contents of this table evenly.

③Finally, copy the personnel table below the salary header content in excel 2010, then select the serial number column, use the excel 2010 sorting function, choose to sort from small to large, and choose to expand the selected area item in the sort reminder, EXCEL 2010 will be arranged in order 1, 2, 3, 4..., and the work of making a salary table in excel 2010 is completed.

The above article explains the operation process of making salary slips in Excel 2010. I hope friends in need can learn it.