Traditional Culture Encyclopedia - Almanac inquiry - How to use the program to match the dates in the table with the perpetual calendar?

How to use the program to match the dates in the table with the perpetual calendar?

Step 1: Open an excel table that needs to automatically generate a calendar, and click the Office button in the upper left corner.

Step 2: Click Excel Options to open the Excel Options dialog box.

Step 3: Select the "Customize" option on the left, click the drop-down button marked by the red arrow, and then select "The command is not in the ribbon".

Step 4: In the drop-down option, select Other Controls and click the Add button.

Step 5: After setting, click OK in the Excel Options dialog box.

Step 6: Click the icon added to the ribbon.

Step 7: Pop up the "Other Controls" option box, select "Calendar Control 12.0" and click "OK".

Step 8: Hold down the left mouse button and drag, and the calendar will be automatically generated.