What is an attendance sheet?
The attendance sheet is a voucher for company employees to go to work every day, and it is also a voucher for employees to receive wages, because it records the number of days that employees work. The attendance sheet contains specific commuting times, including lateness, early departure, absence from work, sick leave, personal leave, and vacation. Time sheets can serve as "evidence" of the text.
How to prepare the 2021 attendance sheet?
1. We give a name to this sign-in form in the first line, so that even if the sign-in forms are sorted together in the future, we can quickly find the one we need.
2. Starting from the second line, we can enter the unit, name, office phone number, mobile phone number, WeChat ID and other information we need or how to contact us in the future..
3. Then we start processing the table. We select the first cell, click and hold the left mouse button, move right to above the last column of the second row, select all the cells in the first row, and then click Merge Cells Just fine.
General Tips for Attendance Sheet 2021
1: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
2: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
3: Quick copy and paste
Select one or some data, and then move the cursor to the lower right corner of the selection box. When the cursor turns into a plus sign, drag it downwards, and it will intelligently fill in 1, 2, 3... for you.
4: Automatic line wrapping
After typing the text in the cell, find the "Automatically wrap" button on the toolbar and you can freely switch the text between wrapping and not wrapping.
Recommended by the editor of Huajun Software Park
it works
it works
it works