Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

MS Excel - question re autocorrect

  • 22-07-2011 12:51PM
    #1
    breadmonkey
    Registered Users, Registered Users 2 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

  • #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.


  • #3
    CreepingDeath
    Closed Accounts Posts: 8,015 ✭✭✭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