Payroll

The salary table mainly records the employee's name, position, actual days of attendance, basic salary, bonus, deductions, actual payment amount, signature, remarks, etc. Huajun Software Park provides downloads of high-quality Excel templates and salary table excel templates. The source files can be obtained by downloading, which can be edited, modified and replaced by you. To download the salary table template, go to Huajun Software Park.

General tips for payroll forms

      1. Insert and delete cells

In the cell tool box, you can quickly insert or delete cells with one click. For example, sometimes when typing, a row of data is missed. Here, click "Insert Row" in "Insert Cell" under "Rows and Columns" and it will be OK.

2. Set the column width in millimeters

By default, the row height and column width units in Excel are points. What should you do if you want to set the row height in millimeters? Click the [Page Layout] view button in the lower right corner of the worksheet, and then set the row height and column width. The unit is cm, which can be accurate to 0.02 cm.

3. Fill merged cells

How to quickly organize a worksheet with merged cells? It’s actually very simple: just select the data range and unmerge the cells first. Then press Ctrl+G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl+Enter.

1. The details are more outstanding!

2. BUG gone without a trace