Question

Excel: turn off autocorrection - here's how

Answer 1

Office 2013 and newer
1st step:
2nd step:
3rd step:
4th step:
Office 2010 and older
Quick start guide: Office 2013 and newer

---

If necessary, deactivate the auto-correction function in Excel. We'll show you how it's done..

Thanks to AutoCorrect, incorrectly written formulas and typing errors are automatically corrected in Excel. The function uses a list of typical spelling mistakes and symbols to make it easier to find and correct. With some entries, however, this otherwise helpful function can become a disruptive factor. In this article, we explain how to turn off auto-correction in Microsoft Excel.

Look here for more tips on how to work efficiently with Excel.

• Office 2013 and newer
• Office 2010 and older

Office 2013 and newer

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

To turn off automatic correction, first open Excel. Switch to the " File " tab .

2nd step:

Then click on " Options ".

3rd step:

In the newly opened window, go to " Document Review" on the left and then click on " Autocorrect Options ".

4th step:

The automatic correction cannot be deactivated with one click. To switch it off completely, remove all ticks in the " Autocorrect " tab . Finally confirm with " OK " and close the window by repeatedly clicking " OK ".

Note: Texts in the form of hyperlinks are not automatically corrected.

Office 2010 and older

As an Office 2010 user, select the " File " tab. Then click on " Word Options ", then on " Document Review " and " Autocorrect ". If you are using Office 2003, you can switch off the autocorrect function via the " Extras " button and then " Autocorrect options ".

Quick start guide: Office 2013 and newer

1. Open Excel and click on the " File " tab .
2. Go to " Options ".
3. In the new window, switch to the " Document review" tab and select " Autocorrection options " there.
4. Remove all ticks in the " Autocorrect " tab and confirm with " OK ".

---