Steps to make a pay stub using Excel

1. Insert the required number of rows in the first line first (according to the number of inserted rows in **, you can insert it upwards or downwards, in this case it is inserted down).

2. Select the cell and shortcut key.

Ctrl+D (fill content down). You can also click the Start menu bar to find the fill icon.

To select a cell, the bold color of the border is selected, and the result is filled.

3. Copy the serial number in the last column of **, and the serial number should be copied 2 times.

4. Select the whole column of data, don't choose the wrong one here, it is to select the whole column of data in the last column, and it is to select the whole column of data.

5. Then select Data-Sort-Ascending in the pop-up sort warning and select Default.

Select Default.

Pay slips. That's it.

6. In this way, you will see the effect of no border when you print the salary slip, and if you need a border, exit the print preview.

Print a preview effect.

7. Add a border to **, you can find the setting of the border in the toolbar below Start, set it freely according to your needs, and you can print and preview it again after setting, until it is set to what you need.

Set the border to **.

Finally, for the sake of demonstration, only 6 rows of data are intercepted in this example, and the manual operation is faster than this. This method is a relatively quick and easy method to use with large amounts of data.

Two approaches. 1. YesMade in excel

Insert multiple rows of sequential numbered headers into the payroll, then sort them and split them into one row header + one row of data, so as to print it out. Crop and distribute it, or send screenshots directly to employees.

However, the amount of work required for this approach is relatively large.

2. If you want the company to pay payslipsEfficient, compliant, and secure

It is possible to give advice to the company and useProfessional payslip toolA few secondsYou can pay all the pay slips for everyone.

Upload the excel payroll - the machine automatically disassembles it into a payslip - for issuance configuration - one click**).

And the professional pay slip tool is inFunctional aspectsMore powerful.

Enjoy pay slips

2. It can be signed and signed, and the signature record can be exported. It can be recalled, retransmitted, and sent at a regular time. Customizable pay stub templates.

4. With the security support of Alibaba Cloud, we have signed a confidentiality agreement with customers, and our salary data is encrypted in multiple ways.

Register on the official website to try it out

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!