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

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

  1. 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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: