To automatically capitalize day names in Excel, follow these steps:
- Open Microsoft Excel.
- Click on the File tab.
- Click Options.
- Click Proofing.
- Click AutoCorrect Options.
- Check the box next to Capitalize day and month names.
- Click OK.
Now, whenever you type a day or month name into a cell, it will automatically be capitalized. For example, if you type "january" into a cell, it will be changed to "January".