Excel.Tips.Net: Automatically Capitalizing Day Names

By Allen Wyatt for Excel.Tips.Net

Automatically Capitalizing Day Names in Microsoft Excel

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:

1.Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 display the File tab of the ribbon and click Options.)
2.At the left side of the dialog box, click Proofing.
3.Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box. (See Figure 1.)

auto capitalize in excel

Article Continued Here

 789 total views,  2 views today

(Visited 1 times, 1 visits today)

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.