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 online 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. Letters that would be uppercase using the other options will be slightly larger than letters that would be lowercase using the other options.Conrad would like to mimic the "small caps" capability of Word within Excel. NOTE: Small caps in the Font dialog box can be used in conjunction with the other two methods for changing case. Confused? It’s a bit like strikethough or superscript formatting which changes the appearance in the document, but the underlying letters haven’t changed. They change the look of the letters but don’t change the underlying Upper/lower case of the letters. These two ‘Caps’ options are different from regular Change Case choices. All caps – All letters will be capitalized, the same as if UPPERCASE was selected using the method described above.Small caps – All letters will be capitalized, but letters that were already lowercase will be slightly smaller, as shown below.There are two options for capitalization on the Font dialog box. Always look for them on the ribbon and click to discover a lot more choices than the basic Office ribbon offerings We’ve talked about those little icons many times at.
The Font dialog box is under the arrow in the bottom right corner of the Font group of the Home tab on the Ribbon. There are two lesser known change case options hiding under the Home | Font part of the ribbon. Uppercase letters become lowercase, and all lowercase letters are changed to uppercase. Capitalize each word – the first letter of each word will be uppercase, and the rest lowercase.Uppercase – all the selected text goes to UPPER case.Lowercase – all text will forced to lowercase.Sentence case – The first letter of each sentence in the selected text is capitalized and the rest will be lowercase.There are two more choices here than using Shift + F3. When you click the button, a dropdown menu will appear showing different options for you to choose. Sentence case (first letter of each sentence is uppercase and the rest lowercase)Īnother way to change the case of text is to select the text that you want to change and click the Change Case button on the Font group of the Home tab on the Ribbon.This option will toggle around three different case options: To change text using only the keyboard, highlight the selected text, hold down the shift key and press F3. Replace text – good when there’s many words or phrases to change.There are four ways to change the case of existing text in Word: ‘change case’ can become ‘Change Case’ or ‘CHANGE CASE’ without retyping. Change Case options in Word, like many Word features goes beyond the obvious choices on the ribbon.Īlter the upper/lower case of words, phrases or more.