Excel: Stop Excel from AutoCorrecting Certain Words

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: Every time I type the name of my WYA Division, Excel changes "œWYA" to "œWAY,". It is impossible to type WYA without entering it as a formula: ="W"&"Y"&"A".

  1. WYA until"¦

  2. "¦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.

  3. Delete any replacements that cause problems.