up vote 6 down vote favorite
share [g+] share [fb]

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).

link|improve this question
57% accept rate
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
feedback

2 Answers

up vote 11 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

link|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
feedback
up vote 3 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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