Detailed explanation of the method and steps of Excel to create employee pay slips

When it is time for employees to pay their salaries, there is nothing more to worry about finances than employee salary slips. One by one, pasting, a lot of labor. So a pay stub, how do we make it into a pay slip?

Let me tell you. Steps to make an employee pay slip in excel1. Open the made employee payroll, copy the payroll header, and paste it below the payroll.

Figure 1 of the steps to make an employee pay slip in Excel2. Select the pasted payroll header, move the mouse to the lower right corner of the line, and when a black "+" appears, drag down to copy the content of the line. The number of replicated rows is equal to the number of employees, for example, if there are 10 employees, then drag down to replicate the number of 10.

Figure 2 of the steps to make an employee pay slip in Excel3. Select another empty column, which is generally the next column after the end of the salary schedule. It can be a, b, c, or , or . The number is based on the number of employees.

Figure 3 of the steps of excel to make an employee's pay slip4. Copy and paste the subsequent number to the last adjacent column of the payroll header.

Figure 4 of the steps to make an employee pay slip in excel5. Select two sets of serial numbers at the same time, and find the sorting and filtering in the editing function.

Figure 5 of the steps to make an employee pay slip in excel6. Click Ascending.

Figure 6 of the steps of excel to make an employee's pay slip7. In the dialog box that pops up, select Expand the current area, mainly include the entire **, and select Sort. We can also manually select the sorting area before selecting the sorting.

Figure 7 of the steps to make an employee pay slip in excel8. Delete the contents of redundant rows and columns. The pay slip is complete.

Figure 8 of the steps of excel to make an employee's pay slip

Figure 9 of the steps to make an employee pay slip in excelYou may also like:

1.excel how to make pay slips.

2.excel2010 how to make a pay slip.

3.How to do a pay stub tutorial with excel.

4.How to create an employee's payroll in Excel**.

5.excel how to make pay slips.

6.excel how to make pay stubs.

Now there are a lot of software and ** can generate pay slips with one click, which is very convenient and convenient! Time-saving and efficient!

<> believe that when it comes to pay slips, many finance professionals have a headache.

The wages were finally summed up, and they had to be split into pay slips.

There are so many people in the company, do you have to adjust them one by one until dawn!

No! Refuse to work overtime, start with me!

Next, let's take a look at how the excel master who leaves work on time makes pay slips

Quickly create pay slips with just one auxiliary column!

Steps: Add an auxiliary column to the right of the data, enter , and double-click to fill the sequence.

Make a copy of the filled sequence and paste it below the sequence.

Copy the header row of the pay slip and paste it to the left of the secondary column.

Select any data in the series, click the [Data] tab - [Ascending] to sort, and delete the auxiliary column.

In this way, the pay slip is easily made.

Isn't it easy, open Excel and try it out!