Current location - Recipe Complete Network - Catering franchise - How to format the shift schedule?
How to format the shift schedule?
Make a shift schedule, open the Excel table, fill in the header, fill in the date and week, write the name of the person who needs to rest, adjust the spacing between tables, and write the name and month in a table. Add diagonal lines, adjust rows and heights to operate,

1. Open Excel to write the header, open a new Excel table, and fill in the header.

2. Fill in the date and week to confirm the first day of the month, and fill in the corresponding date and week in the form. After completing the form, the remaining dates and weeks will be filled in automatically.

3. Fill in the name of the person who needs to rest, fill in the date and week, fill in the name column of the form, and fill in the name of the person who needs to rest for the company employees.

4. Adjust the spacing. You 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 first line of the header of the shift schedule, select merge and center in the middle of the first line, and write the words of the shift schedule in bold.

5. Write a table for the name month, write the name and month in the table, and press ALt+Enter to wrap the line to write the name.

6. Add a diagonal line. Add diagonal lines, format cells, and select borders and diagonal lines.

7. Adjust the row height and row height, and it can be completed.