How To Temporarily Undo Or Turn Off Auto-Correct In Excel

Posted byMenolPosted inMicrosoft ExcelTags:, , , , ,

22-05-2012

The auto correct feature can run you mad sometimes. For example, today I had to type EHR in Excel and it kept auto correcting it to HER 😦

I did a quick search and following are our options around this:

  • Try Undo-ing (ctrl+z) – this works for earlier versions of excel but not for later versions like 2007
  • Type a space after typing what you want and then undo (ctrl+z) before you leave the cell.
    • You must do this before you press enter, tab, any arrow, or before doing any other thing that would take the focus out of the current cell
    • If you undo (ctrl+z) after going out of that cell then the whole thing you typed will be un-done (deleted).
  • If you need to do this in large scale or can’t have an additional space then you have following two options:
    • Type it in notepad or word pad and copy and paste
    • You can use MS word but then you will have to either keep undo-ing of disable the auto-correct temporarily.

Menol

8 thoughts on “How To Temporarily Undo Or Turn Off Auto-Correct In Excel”

  3. Type your text and, while the cell is in edit mode, select it (in the cell or in the type bar) and then hit Enter. This will not make any auto correction.

    Like

    Reply

  4. Just after you type your text, select it (in the cell or in the type bar), while cell is in edit mode, and then hit Enter. This will not make any auto correction.

    Like

    Reply

Leave a comment