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

(Visited 34 times, 1 visits today)

Leave a Reply

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