Well-designed small capitals are not simply scaled-down versions of normal capitals they normally retain the same stroke weight as other letters and have a wider aspect ratio for readability. Small caps can be used to draw attention to the opening phrase or line of a new section of text, or to provide an additional style in a dictionary entry where many parts must be typographically differentiated. For example, the text "Text in small caps" appears as Text in small caps in small caps. Small caps are used in running text as a form of emphasis that is less dominant than all uppercase text, and as a method of emphasis or distinctiveness for text alongside or instead of italics, or when boldface is inappropriate. This is technically not a case-transformation, but a substitution of glyphs, although the effect is often approximated by case-transformation and scaling. In typography, small caps (short for " small capitals") are lowercase characters typeset with glyphs that resemble uppercase letters (capitals) but reduced in height and weight, close to the surrounding lowercase letters or text figures. Cells formatted to use such a font would show text as small caps, even though the actual cell contents are a mixture of upper- and lowercase.True small caps (top), compared with scaled small caps (bottom), generated by Writer When you restart Excel, the font should be available for formatting cells.
SMALL CAPS IN WORD 2007 INSTALL
Just download the font you want (from this or any other reputable source) and install it on your system. Here is one site that may have something you like: If you search the web for a "small caps fonts" (without the quote marks) you should be able to find many candidates, and a good number of them are available for free. (Excel can, however, be configured to still spell check such words.)īecause of the drawbacks, you may want to take an entirely different approach-change the font you use for the cells in which you want small caps. This means that you may have problems when you later run the macro a second time, and Excel's proofing tools (such as the spell checker) won't work on words that are all uppercase. When it is done, the cells will contain all uppercase text, even though the formatting may make it look like small caps. The biggest drawback is that it actually modifies what is in the cells. There are drawbacks to using a macro such as this, and you should be aware of them.
It checks to make sure the cell doesn't contain a formula (formulas are skipped), and then it makes any modification to lowercase characters in the cell. This macro does its work on whatever cells are selected when it is run. With rCell.Characters(Start:=x, Length:=1) If sCharacter >= "a" And sCharacter <= "z" Then
SWords = rCell.Value 'Get the cell contentsįor x = 1 To Len(sWords) 'Act on each letter This allows us to put together a macro that examines what is currently in the cell, and if the character is currently lowercase, convert just that character to uppercase and reduce that character's font size. Each element in the collection represents, as you might expect, a single character in the cell. When using a macro to affect only certain characters within the cell, it is good to remember that each cell has its own Characters collection that can be accessed and modified.
SMALL CAPS IN WORD 2007 HOW TO
Problem is, Conrad doesn't know how to affect the formatting of individual characters in the cell in the manner described. If the character is uppercase (or not a letter), then it should not be affected.
If the character is lowercase and 11 pt, then the macro should change the character to uppercase 9 pt. The only way he can think to do this is to develop a macro that steps through every character in a cell. Conrad would like to mimic the "small caps" capability of Word within Excel.