The AutoCorrect dialog will show up and you can switch between the 4 tabs to enable or disable specific corrections.

In Excel 2007, click the Office button > Options > Proofing > AutoCorrect Options.

In Excel 2016, Excel 2013 and Excel 2010, click File > Options, select Proofing on the left-hand pane, and click AutoCorrect Options.

To have more control over how Excel performs autocorrection in your worksheets, open the AutoCorrect dialog:

Insert special symbols using AutoCorrect.

Add, change and delete AutoCorrect entries.

This tutorial will teach you how to do all this and more. It can even insert check marks, bullet points and other special symbols on the fly without you having to access anything. You can use this feature to change abbreviations to full text or replace short codes with longer phrases. The tutorial explains how to effectively use AutoCorrect in Excel and how to stop it completely or only disable for specific words.Įxcel AutoCorrect is designed to correct misspelled words automatically as you type, but in fact it is more than just correction.

Change language in word 2019