How to make and print a pay stub on a computer

<>2. Add a column of auxiliary serial numbers.

3. Copy and paste a copy of the auxiliary serial number.

4. Use auxiliary columns to sort. When the sorting is complete, a new blank row is added to each row.

5. Copy the payroll header.

6. Select the first column, press Ctrl+G pop-up box, and find the targeting conditions.

7. Select the targeting condition as "Null".

8. OK, press CTRL+V to paste and complete the pay slip.

Make. Next, you can print it out and generate your pay stub.

Here's how:

Figure 1. <>

Figure II. <>

Figure III. 2. Enter =if(c4=) in cell E4"","", vlookup (c4, timesheet!) $a$2:$ak$18,35,0)), enter =d4 22*e4 in cell f4 as shown in Fig:

Figure 1. <>

Figure II. 3. Enter =if(c4=) in cell G4"","", vlookup (c4, timesheet!) $a$2:$ak$18,36,0)), enter =D4 22 8*G4*2 in cell H4 as shown in Fig

Figure 1. <>

Figure II. 4. Enter =if(c4=) in cell i4"","", vlookup (c4, timesheet!) $a$2:$ak$18,37,0)), enter =d4 22 8*i4*3 in cell j4 as shown in the figure:

Figure 1. <>

Figure II. 5. Enter =if(c4=) in cell K4"","", vlookup (c4, performance award!) $a$2:

Figure 1. <>

Figure II. 6. Enter =(M4-P4)-5000 in cell N4 and =round(max((N4)*-0),2 in cell O4), as shown in Fig

Figure 1. <>

Figure II. 7. Enter =if(c4=) in cell P4"","",vlookup(c4,social security!) c$5:f$190,4,0)), enter =m4-o4-p4 in cell Q4 as shown in Fig:

Figure 1. <>

Figure II. <>

It takes eight steps to make a table on the computer, and the specific operation is as follows:

1. Open Excel 2010

2. Then enter the basic payroll item in the first line.

3. Then copy a few lines of payroll items and number them in the back row.

4. Then enter the salary of the corresponding employee and number it.

5. Then select all ** Bu Tan and click "Sort and Filter" under "Start".

6. Click "Custom Sorting".

7. Then set the main keyword of the column to column g, sort by numeric value, and the order is ascending, and click "OK".

8. Then make a salary table, clear the number of column G and print it to send to employees.

Hello, you can save the payroll file in your computer as a pdf first, and then print the pdf file so that you can print out the payroll in full. Here are some specific steps and instructions:1

Open the payroll file, select the File menu, and select the Save As option. 2.In the Save As interface that pops up, select "PDF" as the file type, and then click the "Save" button.

At this point, you have saved your pay slab file in PDF file format. 3.Open the dull or saved PDF file and select the "Print" option.

4.In the print screen that pops up, select settings such as printer device and paper size, and make sure that "All" is selected in the "Page Range" option. 5.

Finally, click on the "Print" button and you will be able to print out all the contents of your payroll. It should be noted that the above steps only apply if you have a printer device. If you do not have a printer device, you can install virtual printer software (such as Adobe Acrobat) on your computer, use the virtual printer to output PDF files, and use other devices or services to print PDF files.

Summary. If you want to print out the full contents of your pay stub on your computer, you can do so by following these steps:1

Open the pay stub file and make sure everything is already on the screen. 2.Click on the File menu and select the "Print" option.

3.In the print settings, select the "All" or "All Pages" option to ensure that everything is printed. 4.

Click the "Print" button and wait for the printer to finish printing. If you have a large payslip, you may need to print multiple pages. In the print settings, you can select the Multi-Page option to print multiple pages on the same sheet of paper, saving print paper.

In addition, you can adjust the page orientation, margins, and other settings for the best printing results.

If you want to print out the full contents of your pay stub on your computer, you can do so by following these steps:1Open the payroll file next to the field and make sure everything is already on the screen.

2.Click on the File menu and select the "Print" option. 3.

In the print settings, select the "All" or "All Pages" option to ensure that everything is printed. 4.Click the "Print" button and wait for the printer to finish printing.

If you have a large payslip, you may need to print multiple pages. In the print settings, you can select the Multi-Page option to print multiple pages on the same sheet of paper, saving print paper. In addition, you can also adjust the settings of the printed page, such as the square and margin, so as to get the best printing results.

Summary. 1.Turn on your computer and go to the financial software; 2.

Find the payroll details report and click Print; 3.Select a printer and set the number of copies; 4.Click Print and wait for the print to finish; 5.

Take out the printed payroll detail report.

1.Turn on your computer and go to the financial software; 2.Find the salary Mingkong brother Liang detailed report Douyun, click to print; 3.

Select the printer and set the number of copies to be printed. 4.Click Print and wait for the print to finish; 5.Take out the printed payroll detail report.

You've done a great job! Can you elaborate on that?

How to print salary details:1First, log in to your financial system, find your payroll detail statement, and print it out.

2.Second, you can use financial software, such as QuickBooks, to print your payroll statements. 3.

Finally, you can use Excel or other financial software to print your payroll detail statement. Reasons for the problem:1

It may be caused by a malfunction of the financial system or an error in the operation of the Caizhou Procurement software. 2.It may be due to inaccurate data in the report or an incorrect reporting style.

Workaround:1Check that the financial system or financial software is working properly and make sure that it is being done correctly.

2.Check whether the data in the report is accurate, and make sure that the report is correct. Personal Tips:

1.Before printing the payroll detail report, be sure to double-check that the data in the report is accurate to avoid errors. 2.

Try to use professional financial software to print the payroll statement to ensure the accuracy of the report. 3.Regularly inspect your financial system or accounting software to make sure it's working properly.

Summary. 1.First of all, the salary details of employees are counted, checked and entered into the statistical software.

2.Create payroll statements, format statistics, and print them out on paper. 3.

Select the payroll statement and print it in a suitable format**. 4.Check the accuracy of the payroll statement to make sure the data is correct, and then print it out.

1.First of all, the salary details of employees are counted, checked and entered into the statistical software. 2.

Make a payroll statement, format the statistical data and print it out to paper. 3.Select the salary statement and the appropriate printing format to print**.

4.Check the accuracy of the grinding source of the payroll statement to make sure the data is correct, and then print it out.

Can you elaborate on that a little bit more?

1.First of all, the salary details of employees are counted, checked and entered into the statistical software. 2.

Make a payroll statement, format the statistical data and print it out to paper. 3.Select the salary statement and the appropriate printing format to print**.

4.Check the accuracy of the grinding source of the payroll statement to make sure the data is correct, and then print it out.

How to print the payslip after the payroll is done Hello dear I am also studying this problem, the method is as follows, print the payslip Method 1: 1, first copy the first line of the payroll details (header), paste it on any line below the payroll, and use the filling handle to drag and copy multiple rows (the number is not less than all the rows of the payroll, assuming that the payroll has 200 rows). Next, insert two columns in front of column a, the first column uses the fill handle to enter the ordinal number, and the odd number is filled (1 3 5......).) to the last line of the payroll (excluding the header copied above) 2. The second column starts from the first row of the copied header and is filled with an even number (2 4 6 ......3. Select all, execute the "Data" "Filter" and "Auto Filter" commands, click the drop-down button in column b, and select "Ascending Sort" in the pop-up drop-down menu, so that the pay slip is ready.

Finally, delete the ab column. But there is only one line in the header of the table, and you can learn from this method.