How to Turn Off AutoCorrect Feature in Excel?

In excel, when typing into the wrong spelled word, it will automatically correct it and display the correct word directly. This auto correct function is controlled by AutoCorrect feature. If we want to keep the wrong spelled word without changing, we can turn off the AutoCorrect feature. This tutorial will introduce you the way to turn off AutoCorrect, if you have this request you can follow below steps to turn off it.

Method: Turn Off AutoCorrect Feature in Excel

When you typing ‘yuo’ in excel, it will be automatically corrected to ‘you’. This is because AutoCorrect feature is built in excel and it is enabled by default. Now let’s turn off it.

Step 1: Click File in excel ribbon, then click Options.

How to Turn Off AutoCorrect Feature in Excel1

Step 2: In ‘Excel Options’ window, click Proofing in the left panel.

How to Turn Off AutoCorrect Feature in Excel2

Step 3: Click AutoCorrect Options button under AutoCorrect options section.

How to Turn Off AutoCorrect Feature in Excel3

Step 4: In loaded AutoCorrect window, uncheck all AutoCorrect feature related options. Then click OK. In this step, you can also only check some options to disable part of AutoCorrect functions per your demand.

Step 5: Click OK to quit previous Excel Options window.

Step 6: Try to enter incorrect word like ‘yuo’ in any cell, you will find it will not be corrected to ‘you’ automatically. AutoCorrect feature is disabled now. If you want to enable it again, just repeat above steps to enter AutoCorrect window to enable all options.

How to Turn Off AutoCorrect Feature in Excel4

Related Posts

Excel Structure Reference

This tutorial introduces the basics of structured referencing in Excel and shows you how to use structured referencing in a table with examples. When you use formulas that reference tables, whether the formula references a part of the table or ...

Excel/Google Sheets: Full Row Reference

Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...

Excel/Google Sheets: Full Column Reference

Full column reference is another cell reference in Excel or Google Sheets, which is used to reference the entire column, for example, if you want to reference the entire column A, you can use the following reference format A: A. ...

Excel/Google Sheets: Expanding Reference

An expanding reference is a reference type in Excel and Google worksheets that extends the range of a cell when a formula is copied to the cell below or to the right. In this article, we will explain how to ...

Excel/Google Sheets: Mixed Reference

In Microsoft Excel Spreadsheet or Google sheets, there is another cell reference, mixed references, where part of the reference is absolute, part of the relative. This article will describe how to use mixed references through specific examples. Mixed Reference When ...