Auto Correct option in Excel

Excel has a great flexible feature of auto correct option which is the most important option which is commonly used in office and now those days it is used worlds wide. Auto correct will used for common typing errors and automatically corrects them as you type, it is also correct two initial capitals. You can also use Autocorrect in expand abbreviations means when you type incl, Auto automatically expand it to include. Autocorrect option is flexible because you can manage the Autocorrect option yourself.

To add AutoCorrect entries manually, do this:

1. Click the tools menu and choose AutoCorrect….. . The Auto correct dialog box appears.
2. In the replace text box, type the error or abbreviation as you usually type it.
3. In the with text box, type the correct spelling of the word or phrase or expansion of an abbreviation.
4. Click Add button to add the new entry to the list of Autocorrect entries.
5. Repeat all the steps from 2 for add more entries.
6. When you finished your work then click on the OK button.

To delete an Autocorrect entry, do this:

1. Click tools menu and choose Autocorrect….. . The Auto correct dialog box appears.
2. Select the entry you want to delete.
3. Click delete.
4. Repeat the steps from 2 how many entry you want to delete
5. When you complete your work click on the OK button.

To customize Autocorrect, do this:

1. Click the Tools menu and choose Autocorrect….. . The Autocorrect dialog box appears.
2. To turn off an option click on the check box you want to turn off the option.
3. When you finished making changes, click OK button.