- 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.
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.
For more resources for Microsoft Excel: