View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I use the "Small Caps" Font option in an Excel speadsheet

Excel doesn't have this kind of formatting.

Maybe you could search the web to find a font that does small caps. Remember
that if you share the workbook with others, they'll have to that font installed,
too.

But you could use a macro that actually changes the font size (character by
character):

http://groups.google.com/groups?thre....supernews.com

execassist1976 wrote:

In Word, one just formats the font and its a toggle box option, however, I
can't find this option in Excel. Problem is, we have it being used in some
spots (document is being updated, and this isn't the first time in Excel
2003), but when we change it, it changes away from the "Small caps" as well.


--

Dave Peterson