If you have an iPad and use a hardware keyboard, select “Hardware Keyboard“.Select “Settings” from the Home screen.How do I turn on auto capitalization on iPhone?Įnable / Disable Automatic Capitalization on iPhone & iPad In the Proofing options, click on the Autocorrect Options. In the Excel Options dialog box, click on Proofing. To get the autocorrect options, click on the File tab. Here you can check the boxes to customize what you want Word to automatically capitalize.Select “Proofing” and then select the “AutoCorrect Options…” button.While working in Word, select the “File” menu and choose “Options“.You can change Word's Auto Capitalization settings to your liking by performing these steps. How do I automatically capitalize the first letter? What is the shortcut to change small letters to capital letters in Excel?įor example, you could copy and paste text from Excel to Microsoft Word and use the shortcut key Shift + F3 to change text between uppercase, lowercase, and proper case. To turn auto - capitalization back on, tap on the slider so that it appears blue instead of gray. Tap the slider next to ' Auto - capitalization ' so that it appears gray instead of blue. To convert the text to lowercase, type =LOWER(A2) instead. This formula converts the name in cell A2 from uppercase to proper case. In cell B2, type =PROPER(A2), then press Enter. How do I turn on auto capitalization in Excel?

Make all text uppercase excel