1. First fill in the numerical serial number on the right side of the table, and drag it down to the bottom of the table to cover the serial number.
? 2. Copy the obtained serial number list directly below it.
3. Copy the title to the bottom of the table, and then drag it to copy. The number of copies is the serial number on the right.
4. Place the mouse arrow in the top blank position of the serial number column, and then click Data-Descending Sort.
5. Finally, delete the serial number list and the redundant blank parts below, and a clearly visible payroll will be ready.
The above is a quick way to make salary slips with Excel, and more related tutorials are in Software Emperor!