Did you know you didn’t need to rely on our title capitalization tool if you use Microsoft Word? Microsoft Word has some basic title capitalization tools that you can use in a pinch if your text is in all caps or has generally messed-up capitalization.
Convert Case in Microsoft Word
Converting case is really simple in Microsoft Word. 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:
- Sentence case: Only the first letter of each sentence is capitalized in sentence case.
- lowercase: Self-explanatory, but this option lowercases all of the letters.
- UPPERCASE: Also self-explanatory, but all the letters are uppercased.
- 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.
- tOGGLE cASE: This style will reverse the case of every letter in the selected text. For example, “tHIs IS PoORLy CAPitaLIZED” will change to “ThiS is pOorlY capITAlized”.
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).
Convert Case in Microsoft PowerPoint
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). This will make sure all your slide headers use the same capitalization rules.
Change Case in Microsoft Excel
Excel is different from the above two Microsoft products because it is a spreadsheet tool based mostly on formulas and data. However, there are formulas built into Excel that allow for some basic title capitalization.
Converting text to uppercase in Excel
Excel has a built-in formula for converting text to uppercase. It’s simply called “UPPER”.
=UPPER(text)
The formula works by converting a string (or cell reference) between the parentheses to uppercase. You can see how this formula is used in the following screenshot:
Converting text to lowercase in Excel
Excel has a built-in formula for converting text to lowercase. It’s simply called “LOWER”.
=LOWER(text)
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:
Converting text to title case in Excel
Excel has a built-in formula for converting text to title case. It’s simply called “PROPER”.
=PROPER(text)
The formula works by converting a string (or cell reference) between the parentheses to title case. You can see how this formula is used in the following screenshot:
Conclusion
Overall, Microsoft Office has some great tools for capitalizing titles and text. While they don’t offer checks against the latest style guides, they work pretty well. Go ahead, try using the built-in Microsoft Office capitalization tools!