What should I do with the payroll?

Step 1: Formulating the calculation formula of total wages.

First open Excel, then insert a new worksheet and rename it "Payroll Table". Select cell A 1, enter the formula in the edit field, and then press Enter to confirm. The formula is: "=IF(MOD(ROW (), 3)=0", "IF(MOD(ROW (), 3)= 1, payroll! A $3, index (payroll! $A:$Q，NT((ROW()- 1)/3)+4，COLUMN())).

Then select cell A 1 and place 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, and release the left mouse button to column P, thus completing the copy of the first line of formulas.

Step 2: Copy the formula.

First select the cell area of A 1: P 1, and then place the cursor in the lower right corner of P 1. When the cursor becomes a black cross, hold down the left mouse button, drag the mouse down, and release the left mouse button when it reaches the corresponding position, that is, copy the formula. At this time, you can see that the function of the payroll has been basically realized.

Step 3: Format setting.

Select cell A 1, click the right mouse button, select format cell → border → outer border in the shortcut menu, and click OK to complete the setting.

Step 4: Use a format brush.

Select the cell A 1, and then click the Brush Format button. When the cursor becomes a combination of a hollow cross and a format brush symbol, hold down the left key and drag the mouse to copy the entire table format.

Step 5: Cancel the zero value display.

Click the Office button in the upper left corner to open the menu, and then click Excel Options → Advanced → Show the options of this worksheet → Remove the check in front of "Show zeros in cells with zero values" → OK. Now, the zero value we see in the current worksheet will no longer be displayed.

However, the knowledge to be learned here is to set the zero value not to be displayed. In Excel2003 and other versions, to set not to display zero value, just click Tools → Options → View tab in the menu and uncheck the "Zero Value" check box. In Excel2007, many functions are placed in Excel options.

Step 6: Improve the table.

Adjust cell spacing according to the width of cell display content, set font, font size and text center, and improve the worksheet. Then, it is necessary to print out the payroll and cut it out for distribution.