How do you do an Excel pay stub?

Step 1: Prepare the calculation formula for the pay slip.

First open Excel and then insert a new worksheet before renaming it to "Payroll Slip Table". Then select the A1 cell, enter the formula in the bar, and press the Enter key to confirm. The formula is:

if（mod（row（）,3）=0，"",if(mod(row(),3)=1,salary schedule! A$3,Index (Salary Statement!) $a:

q,nt（（row（）-1）/3）+4,column（））

Then select the A1 cell, put the cursor in the lower right corner, when the cursor changes to a black cross shape, hold down the left mouse button, drag the mouse to the right, drag to the p column and release the left button, so that the first line of formula is copied.

Step 2: Copy the formula.

Select the A1:P1 cell area first, then place the cursor in the lower right corner of the P1 cell, when the cursor changes to a black cross shape, hold down the left mouse button, drag the mouse down, reach the corresponding position and then release the left button, that is, complete the copy of the formula. At this time, you can see that the function of the salary slip has been basically realized.

Step 3: Format settings.

Select cell A1, right-click, select "Format Cell" "Border" "Outer Border" in the shortcut menu, and click OK to complete the setting.

Step 4: Use the Format Painter.

Select the A1 cell, click the format brush button, when the cursor changes to a combination of the hollow cross and the format brush symbol, hold down the left button, drag the mouse to complete the entire ** format copy.

Step 5: Disable the display of zero values.

Click the office button in the upper left corner to open the menu, click "Excel Options" "Advanced" "Display options for this worksheet" in the lower corner, remove the check mark in front of "Show zeros in cells with zero values" OK. Now, the zero values we see in the current worksheet will no longer be displayed.

However, the knowledge that needs to be learned here is that the zero value is not displayed. In Excel 2003 and other versions, to set the zero value not to be displayed, click the menu "Tools" "Options" "View" tab, and cancel the "Zero Value" checkbox. In Excel 2007, many functions are put into Excel options.

Step 6: Perfect**.

Adjust the distance of the cells appropriately according to the width of the cell display content, and set the font, font size and text centering to improve the worksheet. Then you need to print out the pay slip, and then cut it and then you can pay it.

The above six simple steps are the steps to make a pay stub.

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

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.

Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems.

How to make pay slips quickly in Excel? It's simple, let me teach you!

excel how to make pay slips, I teach you!

How does execl make pay slips quickly?

The salary schedule should include: the employee's work number, which is the same as the ID number, in order to avoid having the same name; Employee's name; Employee level, such as junior, mid-level, or senior; the department in which the employee belongs; the number of days the employee was in attendance; the employee's basic salary; the employee's salary; Employee performance commissions, such as percentage of sales targets; Attendance awards for employees; personal income tax; The amount of five insurances and one housing fund for employees; the number of days the employee is absent from work; Employees are paid actual wages.

How to make pay slips quickly in Excel? It's simple, let me teach you!

excel how to make pay slips, I teach you!

In Excel, in the worksheet, a column chart is created with "name" and "actual salary" as the data area, the maximum value of the scale is 1500, and the main unit macro is 150.

The steps of the method are as follows:

1. Open the Excel** you need to operate, select the relevant cell, click "Column Chart" in the Insert tab and select a chart style to insert.

2. Use the right mouse button to click on the y-axis of the icon, and then click to select "Set Coordinate Axis Format".

3. Select "Fixed" after the maximum value and enter the scale value "1500", in the same way, the main scale unit is also selected as "Solid Cracking Absolute Certainty" and enter the value "150", and then click "Close" in the lower right corner.

4. Return to excel**, and find that in excel, establish a column chart with "name" and "actual salary" as the data area in the worksheet, the maximum scale is 1500, and the main unit is 150.

It is very simple to make pay slips with EXCE, so let's talk about how Excel makes pay slips.

Start by opening an Excel blank table.

In the first column of the first row, enter the words of the salary table of company xx.

From the first column of the second line, fill in the serial number, name, basic salary, meal expenses, overtime pay, payable wages, insurance deductions, actual wages, remarks and other items, which are simple examples, specific items, according to the actual situation of each company to write.

Use the copy-paste function to copy the text of the second line into many lines, and copy as many lines as there are people in the company.

According to the attendance and salary of the company's employees, fill in the specific situation of each person.

Select the first row from column A to I, and click the Merge & Center buttons in the menu bar to merge these cells into one large cell. If you like the border, you can also add a border to this salary table, I personally don't like to look at the border, it feels messy, so, here, it's OK, after printing it out, each person accounts for two lines, use scissors or a knife to cut off everyone's data, send it to everyone's hands, and the pay slip will be made.

Let's create a new excel** and enter the basic information of the employee's salary.

We enter 1 in cell i2, and then move the mouse to the lower right corner of cell i2, a small plus sign will appear, hold down the ctrl key on the keyboard to pull down, you can directly fill the cells in order, you can pull all the way to the last one.

<>2. Then calculate the subtotal of the deduction: enter the formula =sum(g5:k5) in cell l5, and then pull down to fill.

3. Then Punzhou enters the formula =sum(c5:f5)-l5 in Senhui M5 cell to calculate the salary payable, and then pulls it down.

4. Subtract the individual income tax from the payable salary to get the actual salary, enter the formula =M5-N5 in the O5 cell, calculate the actual salary, and then pull it down.

5. In this way, the salary schedule is completed.