How to make a calendar with tables?

How does excel make a beautiful calendar? A tutorial on making calendars with excel tables

1, open Excel tables, select all tables, and set the column width as shown in Figure 2.

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.

3. In column A, 2 cells are selected from every 2 cells, and a total of 10 cells are selected to form 5 groups. Fill the merged cells with purple and the fonts with white, enter the number of weeks, and then enter the number 1-5 in1.

4. Every other column of cells on the right side of the week number, select two cells to merge into 1, which requires two groups. According to this method, first merge other cells, and then enter a number with the date of 1-3 1.

5. Enter the date of the lunar calendar to the right of the date number.