Tools/materials: Lenovo s3, windows 10, excel2020.

1, open Excel and write it.

Open the newly created Excel form and fill it in.

2. Fill in the date and week.

Confirm the day of the week on the first day of each month, and fill in the corresponding date and week in the form. When you pull back the form, the remaining dates and weeks will be filled in automatically.

3. Fill in the name of the person who needs a rest.

Fill in the date and week, and fill in the name column of the form with the names of people whose employees need to rest in the company department.

Step 4 adjust the spacing

Need to adjust the line spacing of the table, adjust the header and the first column of the list, adjust the header, left-click the header with the shift table in the first row, select merge center, and write the words of the shift table in bold in the middle of the first row.

5. Write a table with the name and month.

Write down the name and month in the table, and press ALt+Enter to write down the name.

Step 6 add diagonal lines

Add diagonal lines, format cells, and select borders and diagonal lines.

7. Adjust lines and heights

Line height adjustment completed.