How to Capitalize in Microsoft Office Products – Word, Powerpoint, Excel

0

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”.

Microsoft Word - Uppercase all caps capitalizationTo 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.

Microsoft Powerpoint - capitalization

 

Convert 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:

Excel uppercase formula

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:

Excel lowercase formula

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:

Excel proper case formula - title case

 

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!

LEAVE A REPLY

Please enter your comment!
Please enter your name here