Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MS Excel - question re autocorrect

Options
  • 22-07-2011 12:51pm
    #1
    breadmonkey
    Registered Users Posts: 3,608 ✭✭✭


    I have a small but irritating problem. I'm going to have to input "MPa" into a very large spreadsheet about a zillion times in the next couple of weeks. When I type "MPa", Excel automatically changes it to "Mpa". Is there any way to turn off the auto-correct? I know I could do a find and replace at the end but it annoys me to look at.

    Thanks


Comments

  • Options
    #2
    mp22
    Moderators, Business & Finance Moderators, Regional South Moderators Posts: 6,854 Mod ✭✭✭✭mp22


    Excel 2007 hit the file button (top right)excel options-proofing-auto correct options.


  • Options
    #3
    CreepingDeath
    Closed Accounts Posts: 8,016 ✭✭✭CreepingDeath


    Yep, there's a way to customise the auto-correction.

    1. Go to the Excel main drop down menu on the left hand side (for creating new files, opening existing files etc.. )
    2. There's a button which says "Excel Options", click on it
    3. In the "Excel Options" dialog box, select "Proofing" in the list on the left hand side
    4. There's a button for "AutoCorrect Options" in there
    5. There's a checkbox in the autocorrect options to say "Correct TWo INitial CApitals" - disable this to fix your problem.


Advertisement