Microsoft excel 2010 autocorrect

After you get into the Excel Options window, you can follow the same way that we mentioned in method with Classic Menu for Office to edit AutoCorrect settings. Brings the familiar classic menus and toolbars back to Microsoft Office , , , , and Supports all languages, and all new commands of , , , , and have been added into the classic interface. Brings Tabbed User Interface to Office.

Additionally, you can turn options on or off the following options. The first option controls the autocorrect logo lightning bolt that appears after each automatic correction:.

Please note that the autocorrect button does not appear in Excel anyway, clearing this box prevents the lightning bolt from appearing in Word and some other applications. By default, additional actions are disabled.

To turn them on, select the Enable additional actions in the right-click menu box, and then select the action you want to enable in the list. To trigger the action, right-click a date in a cell, point to Additional Cell Actions , and click Show my Calendar :. Please note that the math conversions only work in equations, but not in cells.

However, there is a macro that allows using Math AutoCorrect outside math regions. It may sound strange, but AutoCorrect in Excel is not always a benefit. For example, you may want to insert a product code like "1-ANC", but it is automatically changed to "1-CAN" each time because Excel believes you've misspelled the word "can".

In many situations, you may not want to stop autocorrect in Excel completely, but disable it for particular words. The screenshot below shows how to turn off the autocorrect of c :. Instead of deleting, you can replace c with c. For this, type c into the With box, and click Replace. Sometimes, you may need to prevent autocorrect of a specific entry just one time. In Excel, this deletes the entire cell value instead of reverting the correction.

Is there a way to undo AutoCorrect in Excel? Yep, here's how you can do this:. For instance, to undo the autocorrect of c to copyright, type c and then type a space.

In some situations, you may want to extend the standard list of misspellings used by Excel AutoCorrect. As an example, let see how we can force Excel to replace the initials JS with the full name John Smith automatically. Typing a long organization or person name takes a lot of time and often causes typing errors and inconsistencies. To resolve this issue, you can introduce abbreviations and expand them through the AutoCorrect feature.

To assign an abbreviation or sequence of characters to the fragment of the text, follow these steps:. In the AutoCorrect dialog box, under the option Replace text as you type , enter your custom entries. The length of an AutoCorrect entry is limited only by the available memory.

After entering or selecting an AutoCorrect entry, you must give it a unique name. For example, don't name an entry Mr. When you don't make the word unique, Word inserts the AutoCorrect entry whenever you type that word, whether you want it to or not. It will require too much effort to revert each auto correction if you have chosen a common word.