While they don’t offer checks against the latest style guides, they work pretty well. Overall, Microsoft Office has some great tools for capitalizing titles and text. You can see how this formula is used in the following screenshot: (If you have the C++ development workload installed, this keybinding may be used by a different. To convert text to all lower case, choose Edit > Advanced > Make Lowercase or press Ctrl+U. The formula works by converting a string (or cell reference) between the parentheses to title case. To convert text to all upper case, choose Edit > Advanced > Make Uppercase or press Ctrl+Shift+U. You can see how this formula is used in the following screenshot:Įxcel has a built-in formula for converting text to title case. The formula works by converting a string (or cell reference) between the parentheses to lowercase. You can see how this formula is used in the following screenshot:Įxcel has a built-in formula for converting text to lowercase. The formula works by converting a string (or cell reference) between the parentheses to uppercase. Converting text to uppercase in ExcelĮxcel has a built-in formula for converting text to uppercase. However, there are formulas built into Excel that allow for some basic title capitalization. This will make sure all your slide headers use the same capitalization rules.Įxcel is different from the above two Microsoft products because it is a spreadsheet tool based mostly on formulas and data. Pick one of 5 case options from the drop-down list. PowerPoint has the same capitalization options as Microsoft Word located under the ribbon option “Home” and then “Change Case” (also found with shortcut ALT+H+7). Move to the Font group on the HOME tab and click on the Change Case icon. As an added tip, to get your sentence into small caps, you can use the Font option, or a different keyboard shortcut. To get to Sentence case, press SHIFT + F3 again, and you’ll get to Sentence case, see below Small Caps. To actually capitalize words using these options, you just select the text you want the rules to apply to and then select case you want to convert to from the menu (or use the shortcut). This will change all your highlighted text to lowercase, just like magic Before After. For example, “tHIs IS PoORLy CAPitaLIZED” will change to “ThiS is pOorlY capITAlized”. tOGGLE cASE: This style will reverse the case of every letter in the selected text. Changelog: 2.4.2 - fix options page shaking on auto scroll bars 2.4.1 - fix issues 2.4.0 - improve filters 2.3.0 - support native browser keyboard shortcuts 2.2.1 - improve title case: hyphens and unicode characters 2.2.0 - introduce operators - add correct list 2.1.5 - improve conversion between methods - allow to disable notifications.Capitalize Each Word: This style is also known as title case or First Letter and is the most common capitalization method for titles and headlines.UPPERCASE: Also self-explanatory, but all the letters are uppercased.lowercase: Self-explanatory, but this option lowercases all of the letters.Sentence case: Only the first letter of each sentence is capitalized in sentence case.If you go to the ribbon option under “Home” for “Change Case” (also found with shortcut ALT+H+7) you’ll find the following options: Converting case is really simple in Microsoft Word.