Excel turn auto correct off?

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

  1. Apple2Mac
    Expand Collapse
    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. yellow
    Expand Collapse
    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. vi2867
    Expand Collapse
    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. vi2867
    Expand Collapse
    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. yellow
    Expand Collapse
    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. Apple2Mac
    Expand Collapse
    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. bruinslacker
    Expand Collapse
    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. bruinslacker
    Expand Collapse
    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