Most valuable professional
  • Excel Book Excerpt

Excel Stop Excel from AutoCorrecting Certain Words

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

LE10000083.jpg 

Figure 113 WYA until…

LE10000084.jpg 

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.

LE10000085.jpg 

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: