How to print pay slips in bulk with excel

You can use the mail merge function, take office2010 as an example, the steps are as follows: 1. Start excel, payroll, for example: 2. Start word, fixed text of payslip, as shown in the following figure:

3. Click the Mail tab, click the Start Mail Merge button, and select Letter in the pop-up menu; 4. Click Select Recipient to use the existing list; 5. Browse the salary schedule created before the selection. xlsx, click to open; 6. After the cursor points to the employee's name, click Insert Merge Field, select the name in the pop-up dialog box, and click Insert; 7. Insert the same work number and salary; 8. Click Done and Merge.

Generate pay slips from the pay scale.

And the pay slips have a header for each.

and the corresponding salary, but also a blank line, how to use the pay table to generate pay slips, you can use mail merge.

or excel function generation.

The following is a salary list of the company, and now the following salary list should be made and printed out of the salary slip of the corresponding personnel.

Method. 1. Step 1, enter the serial number ...... in order in column D of the auxiliary columnStep 2, paste the title line under **, how many people are there, how many lines of title row should be pasted, step 3, the serial number entered in step 1, also paste a copy of the title row and column in the new copy, step 4, press the shortcut key Ctrl+A to select all**, according to column D for custom sorting, that is, [Start Menu]-[Sort and filter]-[Custom sort], in the pop-up sorting dialog box, select [column d] for the main keyword of the column, step 5, after the point is confirmed, That is, you can see the reordered **, and then delete the auxiliary column d column, and you can see the made pay slip.

Drop-down formula in sheet2 table autofill.

Pay slips are printed out one by one

1.The situation of a single line header is the easiest, there is only one line of headers, and any method is possible!

2.Sorting: This first method is the cliché sorting.

It's simple. Add a secondary column next to the data and enter a continuous sequence of numbers. Copy the sequence to the bottom of the entire data region, and copy the region to the table.

3.Positioning method: You can also use [Positioning Condition] to find the pattern of the data, and add the payslip header to the fixed position.

Add a secondary column next to the data and fill in the S-type. Leave the selection, [Ctrl+G] to open [Positioning] - [Positioning Condition], and select a constant. Right-click and select Insert-Entire Row.

Select the header to copy, then select the entire region, [Targeting] - [Null], and paste.

Hello, the steps to print the payslip are as follows: 1. Prepare the completed payroll, then click on the data, select the classification summary, check the pagination of each group of data, and click OK. 2. After confirming, click Preview to see that only one person's salary slip information will be displayed, if you need to delete the summary column, select any row, click Ctrl+G, then select [Null], click [OK].

The production of printed pay slips consumes a lot of manpower and material resources, is not easy to save, and is easy to circulate and leak, and electronic pay slips are relatively more convenient.

If you want the company to pay pay slips moreEfficient, compliant, and secure

You can try to enjoy the pay slip,A 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 in theFunctional 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

The simplest and easiest way to understand is to print pay slips on the basis of Excel payslips, without complex macros and functions.

1. Insert two columns in front of the salary scale.

2. The first column auto-fills the number of sequences.Used to restore payroll).

3. The original salary table part of the first paragraph of the second column is automatically filled in from the name of the person.In the second paragraph, copy the n lines according to the number of people and fill in .The third blank line, the number of filled lines in each paragraph is equal to the number of payroll workers.

4. Sort according to the second column (generate pay slips).

5. Select all content and cancel all borders. Data Menu - Filter - Auto Filter, in the Payroll Item column, select Non-blank, select all non-blank content, apply the border format, and set the border around the former God Banquet. (Set Border Line).

Cancel the automatic filter or select All in the Filter Criteria column just now.

6. Hide the first.

Columns 1 and 2, print**.

Restore the payroll and sort it according to the first column.