Introduction to personnel attendance sheet form Contents included in the personnel attendance sheet:
1. Open Excel, after typing in the cell, move the mouse to the lower right corner of the cell, hold down and drag.
2. Press "Ctrl+A" to select all cells, set the appropriate row height and column width, insert two columns on the left, and enter the "employee number" and "name" respectively.3. Select the part of the table you need to prepare, set the border, click the File tab, select "Print" to preview, and check whether the table fills the page. If not, return to the previous step and add borders to more tables. Once the adjustment is completed, you are done. .
General tips for personnel time sheets
Tick/cross in Excel
First, select the cells you want to check or cross, and select the font as Wingdings 2 in the Home tab.
Then enter R in the cell to make a check, and S to make a cross.
Automatically extract birthday
You only need to enter =TEXT(MID(H6,7,8),"0000-00-00") in the birthday cell and press Enter. *H6 is the cell where the ID number is located
Recommended by the editor of Huajun Software Park
Personnel attendance sheetIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Wage payment schedule for migrant workers,Import unit listDownload to get the source file, which you can edit, modify and replace. To download the personnel attendance sheet, go to Huajun Software Park.
it works
it works
it works