1, open Excel tables, select all tables, and set the column width to 2, as shown in the figure below.
2. Select three groups of cells from B 1 to D 1 to merge into 1, and then drag the mouse to the right to merge the other six groups of cells. Enter the English letters of the week, in red on weekends, in purple on Mondays to Fridays, and in white. As shown in the figure below.
3. Column A selects 2 cells for every 2 cells, and a * * * selection 10 cells are combined into 5 groups. Fill the merged cells with purple and fill the font with white. As shown in the figure below.
4. Enter the number of weeks to be recorded, and enter the number 1-5 from June. As shown in the figure below.
5. Enter the date of the lunar calendar on the right of the date number, as shown in the figure below.
6. Select the numbers in columns C, F, I, L, O, R and U and set them to 20, as shown in the figure below.
7. Finally, you can make a calendar. As shown in the figure below.