Current location - Quotes Website - Signature design - How to make payroll in Excel?
How to make payroll in Excel?
1. After opening the employee salary table, put the mouse anywhere in the data area of the salary data table and press Ctrl+A to select all employee salary data tables. Next, we select the "Data" option in the menu bar, and then select the "Category Summary" command in the hierarchical menu bar.

2. After the "Category Summary" dialog box pops up, we will set the "Category Field" as "Name", and leave the other options as the default items, and then click "OK".

3. When we return to the worksheet, we will see the result of classified summary setting, and insert an employee name and summary cell between each employee;

4. Next, we select the header area from A 1 to H 1, press Ctrl+C to copy, select column A after copying, and press F5 function key (or Ctrl+G shortcut key) to open the positioning condition dialog box;

5. In the "Positioning Standard" dialog box, we select the "null value" radio box, and all others remain in the default state, then click the "Positioning" button to close the dialog box and complete the positioning;

6. Then in the worksheet, we can see that the blank cell in column A has been selected. Remember not to click other cells with the mouse at this time, otherwise the previous selection will be cancelled. We can paste the title line that has been copied to the clipboard directly through the shortcut key Ctrl+V, and the title line is inserted before each salary record;

7. Finally, we switch to the "Data" option in the menu bar and select the "Category Summary" command in the "Hierarchical Menu" to open the "Category Summary" dialog box again. All options remain in the default state, and select the "Delete All" button to complete the employee's salary slip;