Nailing Attendance Sheet It is the personnel department of the company that records the attendance rate of employees and serves as the basis for salary payment 。 The nailed attendance form and Excel template are provided by Huajun Software Park for free download. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about nailed attendance forms, please download the template for free in Guanzhu Huajun Software Park.
Tips for using nailed attendance sheet
It is mainly prepared according to the following contents:
1. Unit name
2. Department name
3. No
4. Name
5. Late
6. Leave early
7. Absenteeism
8. Actual attendance
9. Remarks
General skills of nailing attendance sheet 1: Word wrap Type the text in the cell, and find the "Wrap" button on the toolbar to switch the text between wrapping and non wrapping. 2: Quick Select Formulation Column Select the table area, click the "Create Based on Selection" dialog box under the [Formula] tab, select "First Row", open the name box in the upper left corner after setting, and click the corresponding list to jump to the specified column. 3: Format brush The format brush is easy to use. Just click the format brush, select the format to copy, and finally select the cells to modify. You can modify them in batch. 4: Interlaced fill color makes the table more cool Ctrl + T First, use the shortcut key Ctrl+shift+right arrow+down arrow to select all tables, and then press Ctrl+T. The Ctrl+T method is very fast. It can fill the table with colors quickly, but it can't achieve the color selection. Filling method of self selected color First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all tables. Then select Conditional Format - New Rule in the Start Menu Select the cell to be formatted using the formula, and then enter=MOD (ROW(), 2)=0 * 0 in the format to fill even rows and 1 to fill odd rows Then select the format key, open the fill tab, and select your favorite color to fill
Recommended by the editor of Huajun Software Park
Nailing Attendance Sheet It is a very practical form, and most of the forms filled in are general-purpose. If you just need to nail the attendance form, download it quickly. In addition, Member File Management Form , Contract file management account It is also a good form template. Welcome to click to download it!