Welcome toExcel2007.Tips.Net
Helpful Links
Cleaning Tips
Family Tips
Pest Tips
School Tips
Newest Tips
Controlling How Excel Adjusts Capital Letters
Numbers Mysteriously Divided by 100
Displaying Comment Boxes where You Want Them
Turning the Formula Bar On and Off
Subscribe
Capitalizing Names of Days
Summary: Excel normally capitalizes the days of the week as they are entered in a worksheet. If you don't like this behavior, here's how to make a change.One of the features built into Excel is the ability to automatically capitalize days of the week if you enter them in a cell. For instance, if you type the word "wednesday," Excel would automatically change it to "Wednesday." To control this behavior, follow these steps:
- Click the Office button, and then click Excel Options. Excel displays the Excel Options dialog box.
- At the left side of the dialog box, click Proofing.
- Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box. (Click here to see a related figure.)
- Select the Capitalize Names of Days check box if you want Excel to automatically capitalize for you.
- Clear the Capitalize Names of Days check box if you don't want Excel to make automatic changes.
- Click on OK.
Related Tips:
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities. Check out WordTips: Mail Merge Magic today!