To make an employee attendance sheet, we need to input the basic information of employees, such as number, name, position, etc. , and the daily attendance of this month. This article will take excel20 19 as an example to make a concrete introduction.

0 1 First, we need to make the header.

We open excel20 19, then select 33 columns from the fifth column every 4 columns, and then right-click to select the column width to pop up the interface. We set the column width to 2, and then click OK.

02, we select the area in the figure, and then we click the merged center;

Then we enter the time sheet, so that the header is ready.

Then, you need to identify the table elements.

Enter the basic contents: number, name and position, then we enter 1-3 1, then we enter absenteeism and total, and we adjust the column width of absenteeism and total appropriately;

Finally, the style of the table needs to be adjusted as a whole

Select an area in the chart;

After 06, we click the drop-down arrow next to the border button to pop up the interface. We click on all the boundaries;

Then we click the center button;

After 08, we select the second column, then we set the font size to 20, and then we press Enter.

The final result is shown in the figure, so that we can make an employee attendance sheet.