Current location - Quotes Website - Signature design - Simple method of making payslip
Simple method of making payslip
The simple way to make a payroll is as follows:

1. Add two auxiliary columns to the right of the data area. The settings are as follows: The first auxiliary column: start from the second line of the data area, enter 1, leave a blank line and then enter 2, and drop down to fill in the data. Second auxiliary column: from the third row in the data area, enter 1, leave a blank row and then enter 2, and drop down to fill in the data.

2. Select the auxiliary area, press Ctrl+G on the keyboard, and click the positioning condition button in the pop-up positioning dialog box to open the positioning condition dialog box. In the Positioning Criteria dialog box, select the empty radio button, and click OK to select all blank cells in the auxiliary column area.

3. Right-click any selected empty cell and select Insert Menu Item from the shortcut menu that pops up. In the pop-up Insert dialog box, select the entire row of radio buttons and click OK. At this point, a blank row is inserted every other row in the data table area.

4. Select the title line and press Ctrl+C on the keyboard to copy.

5. Select the data area, press Ctrl+G on the keyboard, and click the positioning condition button in the pop-up positioning dialog box to open the positioning condition dialog box. In the Positioning Criteria dialog box, select the empty radio button, click OK to select all blank cells in the auxiliary column area, and then press Ctrl+V on the keyboard to paste the title.

6. Delete the auxiliary column, so that the payslip is ready.