Excel table quickly making calendar table

The specific operation of quickly making a calendar with Excel tables is as follows:

Operating environment: Redmibook Pro 15 computer, Windows 10 system, WPS Office13.0.503.10/version, etc.

1. Open the Excel table, click Select All Components in the upper left corner of the page, or use the shortcut key Ctrl+A, select the top list to change the column width to 8, and select the right list to change the row height to 4 1. You can also customize the values of rows and columns dragged by the mouse, so that it looks cleaner visually.

2. Start the first line with B 1 and merge two cells into one cell in turn. The number of merged cells is 7, that is, from Monday to Sunday. Enter Monday through Sunday in the merged cells and change the colors of Saturday and Sunday to red.

3. Filling merged cells with colors can make calendars easier to distinguish. The operation is to select the table to fill, and modify the fill color under the Start tab.

4. Take May 2022 as an example. After completing the header Monday to Sunday, enter the date 1 in the table in line B2, Labor Day in line B3, merge C2 and C3, and enter Lunar New Year's Day in the merged table. At this time, the calendar of May 1st was completed. The following dates "2,31"can refer to this method.

5. After the input is completed, modify the text size in the table and finally add a border to the calendar.