Shortcut key to convert small letter to caps in excel

1 answers

Tjones 1066

In excel 2007, it's Shift-F3. Answered May, 10 2011

Lakers 1160

137

shortcut how to change small letter to capital letter in excel 2007

Hi,you can make it with the Module item on the insert menu in VBA to realize it:

Sub ChangeCase()
    Dim Rng As Range
    On Error Resume Next
    Err.Clear
    Application.EnableEvents = False
    For Each Rng In Selection.SpecialCells(xlCellTypeConstants, _
             xlTextValues).Cells
        If Err.Number = 0 Then

Answered Nov, 11 2010

Lyoung 504

How to make 1st letter of word in large caps and the rest in small caps

1. Select the text, then right-click and select Font.
2. Under Effects, select Small Caps.
3. Click OK.
4. With the text still selected, press SHIFT/F3. This will change the case. Cycle through several of these changes until the first letters go Large Caps. (This is Title Case.) Answered Apr, 13 2011

Evening 136

how to convert small letter to capital letter in ms excel 2010

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Answered Sep, 23 2010

Search for Related Topics

small caps shortcut key autocad shortcut key capital letters small notepad shortcut key write small 1st st shortcut keys keyboard small letter big letter shortcut key putting letters circles wap key ascii converter portable wpa key ascii converter portable convert small letters caps letters notepad++ short key sql server small letter big shortcut key caps small excel 2003 shortcut keys excel 2007 small capital shortcut key eclipse convert small letter capital

Your Answer

community wiki: community owned posts do not generate any reputation for the owner, have a lower reputation barrier for collaborative editing, and show only a revision history instead of a signature block

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.

Username:
Password:

Create one

Related Unresolved Questions

How to Format the X-axis and Y-axis in Excel 2010 Charts? (1 answers)
How to Change Interval of Value Axis in an Excel Chart? (1 answers)
how can I change page size to a0 in excel (0 answer)
how do you remove the print dotted line from excel (1 answers)
Problem importing task data from excel (1 answers)

Shortcut key to convert small letter to caps in excel

1 answers

More Articles Related • Recent

Recent Searches

Download related software from AFC

RAC1 to the letter 1.3