Toggling ALL CAPS in Word, Outlook, and Excel

Have you ever received an email or come across a document that was in ALL CAPS? I'm not sure why some people choose ALL CAPS for anything other than a heading or for web shouting, but some do nonetheless. Even in a business setting, you occasionally come across over-zealous typists who just don't know better, but what do you do if you need to re-use the content?

Until recently, I've simply re-typed the content, but the other day I came across this little gem:

[Shift]+[F3].

While in MS Word or Outlook, select the text you wish to toggle, and try that key combo to see the text toggle between ALL CAPS, Proper Caps, and lower case type.

If what you have selected is formatted like a sentence, the "Proper Caps" option will only capitalizes the first letter of the first word of the sentence. If the text isn't formatted like a sentence, it capitalizes the first letter of each word selected.

In MS Excel, you can use the following formulas to to change you text to ALL CAPS, Proper Caps, or lower case:

UPPER()

PROPER()
LOWER()

Now, in Excel, the PROPER() formula always capitalizes the first letter of each word in the selection.

Now that should save some serious typing time!

Now you know, 

Garrett Woodroof