No formula for Excel to print a payroll on a per head basis

Source: Internet
Author: User
Tags first row

Use Excel to hit the payroll with a head, useful Word mail merge function, also useful VBA function, also have the use of writing formula directly generated. See Pole Software Office columns (Word, Excel, print payroll by head, only a formula to make Excel on the payroll) but I think, for ordinary employees, these methods appear to be too professional. In fact, flexible, you can not use the formula, direct to Excel by the head of the payroll, the method is simple, suitable for novice users of Excel.

Suppose the company has 100 employees and payroll data in the a2:r101 area. In the first row of the worksheet, the A1:r1 area is the payroll item, as shown in Figure 1. The payroll we need is the first act wage item, the second act of the employee's salary, and the third act of the empty line so that we print after the split.

Figure 1

The first step: first select a column, right-click, in the pop-up shortcut menu click the "Insert" command, insert a secondary column. In A2, A3, A4 cell, enter the number "2", "5", "8" respectively. Select the three cells, drag the fill handle down to cell A101, and add an ordinal number to the cells.

Step two: Copy the cell a1:r1, then click in A102 cell, and paste. Select a102:r102 cell, position the mouse over the fill handle, press the right button, and drag the fill handle down to the R200 cell. Loosen the right button and choose Copy Cells in the pop-up menu, as shown in Figure 2. This will replicate 99 payroll items, plus the one in the first line, just 100.

Figure 2

Step three: Enter the number "1" in the A1 cell, and enter the number "4", "7", and "10" in the A102, A103, and A104 cells respectively. Then select the A102:a104 cell to drag the fill handle down to cell A200 to add an ordinal number to all the payroll items.

The fourth step: in A201, A202, A203 input Number "3", "6", "9" respectively. Then select the three cells and drag the fill handle down to the A300 cell.

Well, you must understand now. We added ordinal numbers to each other in Payroll items, payroll data, and blank lines. Now, all we have to do is arrange it in ascending order according to a column ordinal, so we can get the required pay bar, as shown in Figure 3.

Figure 3

The last thing to do is to select a column of data, right-click, and select "Hide" in the pop-up shortcut menu to hide the secondary column, as shown in Figure 4.

Figure 4

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.