How to Put Small Caps in MS Excel Vista

1. Open Microsoft Excel. Choose 'View' from the menu bar and click 'Toolbars' from the drop-down menu. Select 'Formatting' to view the formatting toolbar. There should be a check mark on its left side to indicate that the toolbar is on, and it should appear below the standard toolbar, which you will recognize by 'Print' and 'Save' icons among many others.
2. Activate the cell or cells that you would like to apply the small caps effect. Write all of the text that you would like to have in small caps in uppercase, or capitalized, letters.
3. Highlight the letters that you would like to apply the small caps effect to (the letters following the first capitalized letter in each word or words). Decrease the font size for those letters by accessing the font formatting tools from the formatting toolbar. Repeat to apply this effect to all of the text that you would like to see appear as small caps.