How to make a pay stub excel

First, enter the serial number in the auxiliary column, copy the serial number downward, copy the table header below and paste it into the ** below, click the serial number, and then click ascending in the data, and delete the auxiliary column.

excel how to make pay slips, I teach you!

Payroll summary commonly used excel function.

1) Insert auxiliary columns (2) Sort.

How to make a payroll to a payslip.

Step 1: Open the excel payroll we want to work on.

Step 2: Fill in the serial number in the back column of the salary table (tip: after filling in 1 in g2, put the mouse on the lower left corner of g1, a + appears, click + 2 times, and it can be automatically filled), and copy it twice.

Step 3: Copy the header 6 times.

Step 4: Sorting, the main keywords are in column g (that is, the column we add the serial number), ascending; The secondary keywords are listed in column F (that is, the column that should be paid) and click OK.

One HR provides the latest and most complete excel payroll template, salary style, welcome to use it! After making the excel payroll, the form of payslips is also a lot of HR distressed, if the traditional form of paper payslips is used every month, then for large enterprises with many personnel, it will be a very large workload, recommend a personnel payslip ** platform.

Method 1: Sorting method.

Step 1: Open the payroll Enter 1, 2, 3 ...... in the last blank column of the payroll(Note: The number entered is the same as the number of rows on the payroll).

Step 2: Enter down below the number you just entered, one row less than the data above, this column is entered in k9.

Step 5: Enter below cell k15 and keep entering until you click the ascending sort button on the toolbar to delete the data of column k. Add a border and you're done.

Step 5: Enter below cell k15 and keep entering until you click the ascending sort button on the toolbar to delete the data of column k. Add a border and you're done.

Method 2: Functional method.

Step 1: Open the payroll Click the Sheet2 tab and enter =if(mod(row(),3)=0,,in cell A1 of the sheet2 worksheet"",if(mod(row(),3)=1,sheet1!a$1,index(sheet1!

a:$n,int((row()+4) 3),column()) backward to cell J1 (note: the length of the drag should be the same as the length of the original table).

Step 2: Select the A1:J1 area and drag it down to the 20th line (Note: when dragging, you may drag more or less, then you have to look at the original table) Add a border and it will be successful.

The original salary schedule is shown in the chart above.

Copy the same number of workers in the header and place it at the top of **, and add an auxiliary column at the end, fill in the serial number respectively, and add a column serial number in the empty row below;

Then, the auxiliary columns are sorted in ascending order, and the ** region is expanded;

Get the pay slip as shown in the figure below, and you can delete the secondary column at this point.

The practice of pay slips 1Create a new worksheet (pay slip)2Copy the line 1 header from "Payroll" to line 1 of the pay slip 3

Enter the formula in Cell A2 of Payslip: =if(mod(row(),2)=0, salary! A$2,Index (Salary!)

a:$h,int((row()+3)2),column()) and drag to copy to all cell 4File-Page Setup-Worksheet-Top Header Line $1$1, Paper (A4 Horizontal), Font Size (10), Line Spacing (15), Set Border Line 5

Tools-Options-View, remove the tick before "zero".

Send the question as the content (the subject of the email must contain "excel", and I will use this as a basis to identify non-spam emails to avoid accidental deletion), and the excel sample file (showing the current situation and target effect) as an attachment.

excel how to make pay slips, I teach you!

There are many ways, you can install an excel payslip plugin to generate it automatically, you can also use the payslip arrangement formula, of course, the once and for all method is to make a payslip template with word, and then use the mail merge function to read excel payroll data.

Excel pay slip practices.

1.Create a worksheet (sheet2) and copy the unit information from line 1 of sheet1 to row 1 of sheet2.

2.Enter the formula in cell A2 of sheet2:

if(mod(row(),2)=0,sheet1!a$2,index(sheet1!$a:$u,int((row()+3)/2),column())

and drag to copy to all cells.

3.Set the border line, font size, and line spacing in the print area, and remove the tick before the "zero value" in the Tools-Options-View.