Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Intelligent Title Case.

Intelligent Title Case

by Allen Wyatt
(last updated September 23, 2017)

9

Word allows you to adjust the case of selected text. If you are using Word 2007 or a later version you can make sure the Home tab of the ribbon is displayed and then clicking the Change Case tool (Aa) in the Font group.

You'll see a list of different ways in which Word can adjust the case of your text. One of the most common case changes is title case. This type of change results in each word of the selected text being uppercase, while the rest of the letters are in lowercase. The only problem with this is that Word is rather indiscriminate in what it capitalizes. For instance, if you select the text "this is a test" and then use the Change Case dialog box to change the text to title case, you end up with "This Is A Test." Common rules of capitalization, however, would dictate that the "short" words ("is" and "a") should not be capitalized.

This is where a macro comes in handy. You can create a macro to intelligently apply title case to a text selection. The macro can be programmed so that it ignores a specific set of words while doing its work. Consider the following macro:

Sub TitleCase()
    Dim lclist As String
    Dim wrd As Integer
    Dim sTest As String

    ' list of lowercase words, surrounded by spaces
    lclist = " of the by to this is from a "

    Selection.Range.Case = wdTitleWord

    For wrd = 2 To Selection.Range.Words.Count
        sTest = Trim(Selection.Range.Words(wrd))
        sTest = " " & LCase(sTest) & " "
        If InStr(lclist, sTest) Then
            Selection.Range.Words(wrd).Case = wdLowerCase
        End If
    Next wrd
End Sub

When you select some text and run this macro, the first thing it does is to change the text to Word's standard title case. It then steps through the words in the selection (Word makes the words available in the Words collection), examining each one. Each word is extracted and placed in the sTest variable, which then is converted to lowercase. The contents of sTest are then checked against the lclist string to see if there is a match. If there is, then the word in the original text is converted to lowercase.

The key to the macro is the lclist string. This string contains a list of words that you want to always appear in lowercase. These words are surrounded by spaces—including the first and last words of the string. When the sTest comparison is done, sTest contains a leading and trailing space so that successful matches can be made. (The spaces are included so that there are no mistakes in word matching, for instance matching "he" to a part of "the".)

Note, as well, that the comparison portion of the macro doesn't pay attention to the first word in the text selection. This word is assumed to be the first word of a phrase or sentence, which should always start with an uppercase character.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3868) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Intelligent Title Case.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Editing Reports

The Report Manager allows you to create specialized reports that can be easily printed from your worksheet data. This tip ...

Discover More

Hash Marks Displayed Instead of Cell Contents

Have you ever entered information in a cell only for it to appear as hash marks? This tip explains why this happens, how ...

Discover More

Hiding a Chart's Legend

When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. You may not want ...

Discover More

Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!

More WordTips (ribbon)

Absolutely Getting Rid of Formatting

Need to get rid of the formatting applied to a bunch of text? One of the easiest ways to do this is to use Notepad in ...

Discover More

Making a List of Words Italic

You can use Find and Replace to change the attributes of text in your document. When you want to make changes to lots and ...

Discover More

Detailed Measurements

Want to know exactly how far something on the ruler is from the left and right margins of your document? It's easy to ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 4 - 0?

2019-04-01 09:13:22

rcstan

Just using Shift + F3 to cycle between initial caps, all caps and no caps to change the case of selected text is still the most straightforward short cut of all.


2019-03-31 14:28:50

Pete u'Line

From the comments, it's clear that "title casing" is not such a simple think, although most users use it not worring so much, which is not a happy new.
I found the tip looking for a different missing feature of the standard Title Case command. In romanic languages title casing is not the rule, but Sentence case is preferred. In this language, as not in English, the use of apostrophe can be frequent (and not always at the end of words, like "Jim's"), and Title Casing is increasingly used.
When you have apostrophe at the begining of the sentence, you need "L'Endemà del Big Bang" (first letter after the apostrophe in upper case).
When the apostrophe is in any other position (but before an entire word) you will want "Cercant l'Arca Perduda" (particle in lower case, the word beyond the apostrophe with the first character in upper case.
If someone founds that of any interest... I have no skills in writting VBA code... yet.


2018-06-24 02:02:27

Anton Fourie

Further to my previous comment...

I used the macro in a table, selecting multiple cells (sentences), which caused the isse (OK, I'm a NOOB!)

Is there any way to change the macro so I can use it on multiple sentences?

Thanks!!


2018-06-24 02:00:05

Anton Fourie

This has worked for me for a long time, and now it stopped working - ALL words are now capitalized. Grrr!!! What is wrong?Sub TitleCase() Dim lclist As String Dim wrd As Integer Dim sTest As String ' list of lowercase words, surrounded by spaces lclist = " of the by to this is from a then or for as and when if any on an in at " Selection.Range.Case = wdTitleWord For wrd = 2 To Selection.Range.Words.Count sTest = Trim(Selection.Range.Words(wrd)) sTest = " " & LCase(sTest) & " " If InStr(lclist, sTest) Then Selection.Range.Words(wrd).Case = wdLowerCase End If Next wrdEnd Sub


2017-09-25 13:43:50

Patricia Boyd

Haha, Rod Grealish! Yes, I guess you're right. If "turn on" means "to become disloyal," as in "Disgusted with the team, Joe turned on them and never attended another game," then "on" should be lowercase, as it's a preposition.


2017-09-24 07:55:22

Gary

The macro above will only work for one sentence of course. You normally wouldn't require Title Case for more than that, but just be aware that if additional sentences are selected this macro will cause each of them to begin with a lower-case letter if the sentence starts with one of the words in the LcList (The, This, From, By, etc).


2017-09-24 05:06:38

Rod Grealish

Presumably there is a semantic difference between "Turn On Your Audience with Music" and "Turn on Your Audience with Music" . :-)


2017-09-23 07:55:00

Patricia Boyd

Great! Thanks for the terrific, time-saving tip! To follow up on Patritica Compton's comment, all the publishers I work for (some major publishers and some Ivy League university presses) want verbs capitalized in titles. Thus, "Is," "Are," "Were," etc. , are capped, even though they are short words. Other readers might want to note this guideline. Additionally, and now I'm showing my true nerdiness, words like "on," and "up" are not always prepositions and, at least for my publishers, are capped: "Turn On Your Audience with Music." Finally, most titles capitalize the first and last word of titles, no matter what the part of speech: "On Being a Beatles Fan," "What Is the Earth's Crust Made Of?"
So your fantastic macro can be used anyway, and the user needs just to quickly skim the title afterward to make sure none of the exceptions cited above exist.
Thanks again!


2017-09-23 06:48:57

Patricia Compton

I believe it is a misunderstanding to say that common rules of capitalization require "short" words to be lower-cased. The rule used to be that articles (a, an, the) and prepositions (sometimes all, or sometimes only those 5 letters or fewer long, depending upon the editor) were not capitalized unless at the beginning of the title. "Is" is a verb, and verbs get capitalized no matter how short they are. I do realize that the "common rules" may have changed since many people are no longer sufficiently educated in grammar to understand what part of speech a particular word represents.


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.