Results 1 to 5 of 5

Thread: Excel and capitalization

  1. #1
    Join Date
    Jul 2006

    Excel and capitalization

    I wonder if it is possible in Excel simply switch a cell containing text in lowercase text to uppercase (in something like Word with the Shift + F3). I know that you can not ask a spreadsheet to have all the features of a word processing. Is there any way I can set a column to have the first letter of each word capitalized no matter how the user types it?

    Thank you
    IF you hate me, please don't mention it. I know who hates me and who doesn't. You really do not have to make fun of people....

  2. #2
    Join Date
    May 2008

    Re: Excel and capitalization

    Your Microsoft Office program can make your work easier by automatically correcting capitalization errors. The default options usually work well for most people, so you may not need to modify these options. However, if it is necessary, you can easily customize the automatic capitalization options. for more details see this

    1. Click the Microsoft Office ButtonButton image, and then click Excel Options at the bottom of the window.
    2. Click Proofing.
    3. Click the AutoCorrect Options button.
    4. On the AutoCorrect tab, select or clear any of the following check boxes:

    • Correct TWo INitial CApitals
    • Capitalize first letter of sentences
    • Capitalize names of days
    • Correct accidental use of cAPS LOCK key

  3. #3
    Join Date
    Apr 2008

    Re: Excel and capitalization

    You can have another column which has =PROPER(A1), but that's not quite what you want. You need an event macro. Right-click the sheet tab, select View Code, enter this, which applies to column C (3): -- change the colulmn accordingly.

    Private Sub Worksheet_Change(ByVal Target As Range)
       If Target.Column = 3 Then
           Application.EnableEvents = False
           Target.Resize(1, 1).Value = Application.Proper(Target.Value)
           Application.EnableEvents = True
       End If
    End Sub

  4. #4
    Join Date
    Jul 2006

    Re: Excel and capitalization


    Thank you for those explanations, it works well. By against, is there a way to cancel the execution of Macro, unless I Executive step in the right cell ?

    Thank you
    IF you hate me, please don't mention it. I know who hates me and who doesn't. You really do not have to make fun of people....

  5. #5
    Join Date
    Jan 2012

    smile Re: Excel and capitalization


    I joined this forum just to answer your question!

    I just encountered the same problem at work and there is a much easier and quicker way!!

    1. Click on a blank cell.
    2. Type this text: =UPPER
    3. Click on the first cell in the column that you want to change to upper case.
    4. Drag the corner of the blue box that appears so that it has all the cells you want changed, inside.
    5. Go to the formular bar with the equation and add a bracket to the end.
    6. The formular should look something like this: =UPPER(E2:E13)
    7. Press enter.
    8. All the text will now be in the blank columns/cells. If not, drag the corner of the black box and drag down, and the rest of the data will appear).
    9. Copy all the new data. Right click on the first cell to be replaced and click, 'paste special' and then click 'values'.
    10. Paste this data over the top of the original lower case data.

    Hope this helps!


Similar Threads

  1. Replies: 4
    Last Post: 02-11-2012, 12:36 AM
  2. Replies: 2
    Last Post: 18-02-2012, 03:34 AM
  3. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 09:17 PM
  4. Replies: 6
    Last Post: 25-07-2009, 12:01 AM
  5. Excel: format data capitalization
    By AdityaR in forum Windows Software
    Replies: 3
    Last Post: 11-06-2009, 07:09 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Page generated in 1,653,144,405.51215 seconds with 17 queries