Excel turn auto correct off?

Discussion in 'Mac Applications and Mac App Store' started by Apple2Mac, Oct 26, 2006.

  1. macrumors regular

    Apple2Mac

    Joined:
    Sep 3, 2006
    #1
    Excel is pissing me off

    when I type into a cell LPrecord it auto formats it to read Lprecord, how do I stop it from doing that?

    Also is there a way to turn off auto hyperlink and auto mailto: tagging that annoys the heck out of me too!
     
  2. Moderator emeritus

    yellow

    Joined:
    Oct 21, 2003
    Location:
    Portland, OR
    #2
    Did you look in the preferences?

    I suspect turning off AutoCorrect in the Edit menu would take care of #1.
     
  3. macrumors 6502

    vi2867

    Joined:
    Oct 11, 2006
    Location:
    Eastvale, CA
    #3
    In the Tools and Options menu check the Spelling tab and select ignore words with capital letters. This should fix that...

    [​IMG]

    :)
     
  4. macrumors 6502

    vi2867

    Joined:
    Oct 11, 2006
    Location:
    Eastvale, CA
    #4
    Actually Autocorrect is in the Tools Menu...

    You can actually add your word, so it will correct it the way you want it to be corrected..

    [​IMG]

    :)
     
  5. Moderator emeritus

    yellow

    Joined:
    Oct 21, 2003
    Location:
    Portland, OR
    #5
    That's one way to do it. My way is another.

    Either way.. I don't think the OP looked very hard before posting. ;)
     
  6. thread starter macrumors regular

    Apple2Mac

    Joined:
    Sep 3, 2006
    #6
    That fixed it, I was looking in Prefrences, I forgot there was seperate Tools Menu....
     
  7. macrumors newbie

    Joined:
    Nov 26, 2008
    #7
    Excel is pissing me off too

    My problem is similar but more complicated. Turning off autocorrect fixes it but there should be a better way.

    My issue: I typed "Chase HAS" in a cell when I meant to type "Chase HSA". Now whenever I type Chase HSA it replaces it with Chase HAS. I checked the autocorrect list but it isn't on the list so I can't delete it. I figured this automatic replacement was automatically added to a list just for this document so after I had no other recourse I trashed the document and started over. IT STILL DOES IT!

    I tried using find and replace. It replaces what I've already done but doesn't correct the behavior going forward. I tried adding the opposite Autocorrect to the list i.e. telling it to exchange "Chase HSA" for "Chase HAS", but it doesn't do it. There are a few practical solutions: turning off autocorrect, using find and replace before I save or print so that it looks right, but I shouldn't have to do that. There should be a way to FIX it, not work around it. Does anyone have any ideas of how this is working or how to fix it?

    thanks in advance
     
  8. macrumors newbie

    Joined:
    Nov 26, 2008
    #8
    Nevermind. I feel dumb.

    I figured it out. It wasn't replacing it because I typed it wrong. It thought I was trying to type the word has. I disabled that individual autocorrect and now everything is fine.
     

Share This Page