4 ms·
I was recently trying to write HSA into Excel (as in "Health Savings Account"). Unfortunately HSA is auto-corrected to HAS. In Excel there's no way to undo the
by Someone1234 9y ago
I was recently trying to write HSA into Excel (as in "Health Savings Account"). Unfortunately HSA is auto-corrected to HAS. In Excel there's no way to undo the auto-correct, even if you backspace and retype it re-corrects. Even putting quotes around it in the cell ("HSA") will auto-correct to "HAS".
So now my user experience with Excel is going to Options -> Proofing -> AutoCorrect Options -> [Find HSA on the long list] -> Delete. I took the opportunity to delete them all.
Honestly if this software was written today I don't believe Auto-Correct would be implemented the way it is, it is super lazy with no room for false positives.
- rcthompson 9y agoIf I recall correctly, the secret incantation to suppress auto-correct in MS Office is control+Z right after the correction occurs.
- FabHK 9y agoI've worked with Hong Kong stocks a lot in Excel, and the major stock index is the HIS. No, HIS! HIS! Hang Seng Index, HIS! Arghh... You really have to go to the autocorrect options, as you describe, and remove the HSI->HIS rule, until you get a bloody "HSI" into an Excel cell :-) EDIT: It's actually the Hang Seng Index, not HK Stock Index, but both expansions capture the meaning.
- astura 9y agoOh, God. Excel is the bane of my existence. It does all kinds of crazy stuff that baffles me to no end. I'm sure it all makes perfect sense to an Excel expert but for the casual user who only has to use Excel a few times a year it's a battle with the program. Stuff like interpreting plain numbers pasted as "text only" (example 1234) as dates. And you have to pay close attention because it doesn't really tell you "hey I'm changing what you entered."