Current location - Trademark Inquiry Complete Network - Tian Tian Fund - How to make reward and punishment table with Excel
How to make reward and punishment table with Excel
1. First, set the title bar in the first row of the open excel table according to the cell contents in the figure below.

2. Then enter the number of the employee to be counted in the "Serial Number" column. Adding this column can facilitate the statistics of employees.

3. Then select two cells under the serial number, click the Merge Center button in the toolbar, and enter each sub-element of the Total chain.

4. Finally, select all text cells, click "All Borders" in the toolbar, and add table borders to complete the production.