Traditional Culture Encyclopedia - Almanac inquiry - How to make an excel calendar?
How to make an excel calendar?
1. Create a new blank EXCEL document.
2. Then enter the date in the first column and then enter the date in the second column.
3. Select the second column, then right-click and select Format Cells.
4. Select "Custom" in the number, enter "aaaa" in the General Type, and then click OK. So one day of the week.
5. Then enter the to-do list in the third column.
Method 2:
1. After the date is entered in the first column, the to-do list is entered in the second column.
2. Select the first column, and then click Format-Conditional Format on the menu.
3. select "formula" in the condition 1, and then enter = weekday ($ a2,2) >; 5, $A2 means the referenced cell, 2 means Sunday = 1, and Saturday =7. C is for > 5, pick it out. You can choose the format,
4. Select "Format". > 5 is bold, and the unit cell is yellow.
5. Click "OK". So Friday and Saturday will be shown in bold.
- Related articles
- The sun is burning like an ancient poem.
- What are the five flavors of traditional Chinese medicine?
- How about the third day of the seventh lunar month in 2022? Is this an auspicious day of the zodiac? Is it suitable for breaking ground?
- What year is the Year of the Loong in 2023?
- 1987 Born on the third day of the first lunar month, is it a rabbit or a tiger?
- Is it allowed to bury auspicious days in the Gregorian calendar?
- Are taboos in the yellow calendar credible?
- Dream that relatives get together to discuss how to get along.
- Wei Zi Science and Technology Daily horoscope, is there an official WeChat account with a good horoscope or horoscope?
- The complete works of the yellow calendar in 2022