MS Excel: Turn off AutoCorrect in Excel 2010
Question: In Microsoft Excel 2010, when I type in the three letters ehr in any cell in any of my worksheets, or a new one, it automatically changes the letters to her. Why? How can I stop this?
Answer:Excel 2010 has auto correct features that attempt to make your life easier. Sometimes these auto correct features are not so helpful.
You can turn off this AutoCorrect, by doing the following:
Click on the File menu and then select Options from the drop down menu.
When the Excel Options window appears, click on the Proofing option on the left. Then click on the AutoCorrect Options button.
When the AutoCorrect window appears, uncheck the option called "Replace text as you type". Then click on the OK button.
Then click on the OK button on the Excel Options window to close it.
Now when you type ehr in a cell, it should appear as ehr and NOT be auto corrected to her.