Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Working on Excel 2007 I am trying to populate a cell with the text HSA. However, when pressing enter, the text changes automatically to HAS.

I assume there is a kind of auto spelling correction here, but I can't find how to disable it (and, preferably, only at this cell).

share|improve this question
    
Lol, I was just ranting about this a couple weeks ago because I was writing an email about a HSA account. –  Troggy Jul 17 '11 at 1:22
    
@Troggy - yeah, exactly that... –  ysap Jul 17 '11 at 1:37
add comment

3 Answers

up vote 15 down vote accepted

I would remove that auto-correct word from the list like this:

Office Button > Excel Options > Proofing > Autocorrect Options and scroll down in the list until you get to "hsa", highlight it, and click delete.

You can't really disable it at a cell, but you can at least disable it for that one word you are having trouble with. You can always add it back again later.

enter image description here

share|improve this answer
    
thanks. But in the Proofing tab, the "Ignore words in UPPERCASE" is checked, so why does it insist on correcting me? –  ysap Jul 17 '11 at 1:39
    
The top one is for auto-correct, the bottom one is for when you actually check the spelling (Review tab>Spelling or hitting F7). –  KCotreau Jul 17 '11 at 3:53
add comment

File -> Options -> Proofing -> "AutoCorrect Options" button -> "AutoCorrect" tab.

It has hsa -> has correction rule. Remove it.

P.S. The path is for Office 2010, but should be the same for 2007.

share|improve this answer
    
Thanks, @LazyOne, please see my comment to KCotreau. –  ysap Jul 17 '11 at 1:40
    
@ysap Because those are different/independent settings. Ignore words in UPPERCASE is for spell checking and not AutoCorrect. –  LazyOne Jul 17 '11 at 1:44
add comment

Another quick workaround is to use a formula like this: ="HSA"

share|improve this answer
    
On my machine it corrects the string back to ="HAS" as I type it... –  ysap Oct 18 '12 at 17:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.