MrExcel.com - Your One Stop for Excel Tips & Solutions

Stop Excel AutoCorrecting

June 26, 2003 - by

Bill from the U.K. writes,

On Excel 2000 it is impossible to put “ehr” in a cell – Excel changes it to her. I can fool it by concatenating individual letters (Concatenate(“e” & “h” & “r”) but why doesn’t it like it ? It’s not a spelling or format thing as far as I can see – is it a reserved word!?

This is an AutoCorrect feature. To stop Excel from doing this or any other similar change, follow these steps:

  • From the Tools menu, select AutoCorrect Options
  • On the first tab (AutoCorrect), in the “Replace text as you type” section, there is a long list with a scrollbar. Use the scrollbar to go down to thhrough the alphabetical list to the “e”‘s.
  • Find the entry for ehr. Click that entry to select it. Click Delete.