This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Stop Excel from AutoCorrecting Certain Words
Problem: Every time I type the name of my WYA Division, (Figure 113), Excel changes “WYA" to “WAY," (Figure 114). It is impossible to type WYA without entering it as a formula: ="W"&"Y"&"A".
Figure 113 WYA until…
Figure 114 …you type a space or press Enter.
Strategy: To help correct common mis-typings, Excel has a large list of words that are automatically replaced as you type. This is a good feature, unless you routinely have to type one of the words that Excel thinks is wrong. Luckily, you can edit this list rather than turning it off. Here’s how:
1. Select File, Options, Proofing, AutoCorrect Options or Alt+T+A.
2. On the AutoCorrect dialog, go to the AutoCorrect tab.
3. Scroll down the Replace Text as You Type section until you find the entry for replacing WYA with WAY. Select that line and click Delete.
Figure 115 Delete any replacements that cause problems.
See Also: “Use AutoCorrect to Enable a Shortcut" on the next page.
<-Previous Topic Next Topic->
For more resources for Microsoft Excel: