Font codes for capitalization and small caps

  • Thread starter Thread starter Blue Max
  • Start date Start date
B

Blue Max

Why not add options to the font menu for formatting cell fonts to lowercase,
UPPERCASE, or Proper Caps? Currently, the user must use formula functions
to perform this formatting. The current method has many drawbacks and
limitations. Including the font options suggested above would eliminate
current limitations and would allow the user to designate the cell format
regardless of whether the cell contained a formula or whether the text was
manually input into the cell.

Additionally, we have used programs that include font options for SMALL
CAPS. This allows the user to select a font and then designate that ALL
letters be displayed as uppercase, however the first letter of each word is
a larger uppercase letter (i.e., a capitalized capital). It is a very nice
effect. SHADOW and OUTLINE are two other font options provided by other
spreadsheet programs that would be nice to include in Excel.
 
This newsgroup is intended as a forum to assist those having difficulty
using Excel. Responses to your questions are from (unpaid) Excel users who
give their time to assist others. To pass your opinion to Microsoft, try
links from the following site:
http://www.microsoft.com/mscorp/execmail/feedback.mspx

Fonts are NOT part of Excel. Excel access fonts installed in your system. If
you wish, you can install a Smallcaps font and use it in Excel. Google
produces many sources.

http://www.google.com.au/search?hl=...um=0&ct=result&cd=1&q=font+small+caps&spell=1
 
To Blue Max

Untill MS gets around to complying with your suggestion you could use this
macro for small caps.

Sub Small_Caps()
Dim o As Object
Dim sCap As Integer, _
lCap As Integer, _
I As Integer
Dim testStr As String
Application.ScreenUpdating = False
For Each o In Selection
With o
If Application.IsText(.Value) Then
lCap = .Characters(1, 1).Font.Size
sCap = Int(lCap * 0.85)
'Small caps for everything.
.Font.Size = sCap
.Value = UCase(.Value)
testStr = .Value
'Large caps for 1st letter of words.
testStr = Application.Proper(testStr)
For I = 1 To Len(testStr)
If Mid(testStr, I, 1) = UCase(Mid(testStr, I, 1)) Then
.Characters(I, 1).Font.Size = lCap
End If
Next I
End If
End With
Next o
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP
 
Thank you Gord, I appreciate you sharing a temporary work-around.
Meanwhile, we hope Microsoft will add this functionality in the future.

Thanks,
Richard

*****************
 
Hello Steve,

Thank you for the reply and the links provided. However, I beg to differ on
tthe purpose of the forums. Please note that users are free to submit
questions, comments, and suggestions. In fact, the Microsoft Mail
newsreader (shipping with Vista Ultimate) allows the user to specifically
designate a submission as a product suggestion. Likewise, the newsreader
message listings include a column with icons to identify the type of
submission. For example, a light bulb distinguishes a suggestion from a
question which is identified by a question mark within a blue circle.
Please note that accessing these newsgroups from the Microsoft website also
includes the same features for identifying a new submission as a suggestion
versus a question or comment.

Moreover, some Microsoft webpage links direct users to the forums for
submitting suggestions. You will also note that the link you provided sends
the user to a product page that accepts suggestions for interesting items
like 'Sinhalese Enabling Pack', 'San Fermin Theme Pack', 'Chinese video
Screensaver', etcetera (see attachment). Obviously, not products most are
interested in commenting upon.

I appreciate the search link for 'Small Caps' it has some good reference
links. However, there are programs that can create 'Small Caps' from any
standard Windows font. If you have ever used any of the Corel WordPerfect
products you might be familiar with this feature, it is very nice.

Thanks,

Richard

********************
 
Richard

Whilst Microsoft provides the mechanism for Microsoft newsgroups, rules of
conduct seem to indicate that the newsgroup operates by Microsoft
communities rather than Microsoft itself.

See http://www.microsoft.com/communities/conduct/default.mspx

"Expectations of Service
Microsoft's Role: Microsoft does not offer formal support for the
communities you'll find here."


The Welcome page indicates the purpose is to "Ask questions, share
information, or exchange ideas with others" (i.e. no mention of making
suggestions to Microsoft".

http://www.microsoft.com/communitie...spx?guid=1A61081E-1F66-5F7F-B5BA-04767E55A63B


Microsoft Excel MVP, Chip Pearson knows far more about Microsoft newgroups
than I. See his last dot point on the following in which he advises
"Microsoft employees do not read these newsgroups":

http://www.cpearson.com/excel/HintsAndTipsForNewsgroupUsers.aspx

Microsoft Newsgroups are not moderated. Nobody can control what you write. I
am not trying to attack you. Only to help you obtain maximum benefit from
using the resource.
 
Hello Steve,

Thank you, your explanation was very helpful. We do have a great
appreciation for the volunteers, including yourself, that help with these
communities. For now, we will apparently have to consider our suggestions
as "an exchange of ideas with others." In a way, that is unfortunate,
because the forums seem to be a natural place for users to submit
enhancement requests, especially where there is a tool for identifying the
submissions as such.

Finally, as I indicated, the link you provided only appears to allow the
user to submit requests related to a bizarre set of relatively obscure
applications. Nonetheless, I have found that the support home for any
specific product (such as Microsoft Office or Windows Vista) does appear to
include a contact link, to the production team, that looks like it may be
suitable for enhancement requests.

Thank You,
Richard

*****************
 
Ironically, Word 2007 includes all these font attributes in the fonts
dialog. It is sad these basic attributes are not also included in Excel.

****************************
 
Back
Top