Current location - Quotes Website - Personality signature - Excuse me, how to make EXCEL payroll into payslips and print them out for workers to see? Ask for detailed steps or help me make a template.
Excuse me, how to make EXCEL payroll into payslips and print them out for workers to see? Ask for detailed steps or help me make a template.
Make payroll:

Step 1: Write the same "1" symmetrically, and then select all two symmetrical "1" to make the cursor become "ten" and drop it down to the last employee, as shown in the following table (1).

Step 2: Select all from the symmetry "1-3". Edit-Positioning-Positioning Criteria-Select Null Value-OK-Insert-Line-OK. ? The following table (2)

Step 3: Select the first row (header), click Edit-Copy, then select the first column (name column), and click Edit-Positioning Criteria-Null Value-OK-Edit-Paste-Finish.