Set the AutoCorrect Function in Excel

This guide provides a practical overview of Set the AutoCorrect Function, including its main features, benefits, limitations, and important considerations.

To set up the AutoCorrect function in Excel, do the following:

Step 1: On the card File -> Option:

Step 2: The Excel Option dialog box appears -> Choose Proofing -> AutoCorrrect Options.

Step 3: The AutoCorrect Englich dialog box appears in the section:

- Replace: Enter the abbreviation name.

- With: Enter content for the abbreviation.

After you finish typing click Add to put the abbreviation into the dialog box:

Step 4: The abbreviated phrase has been added -> click OK to complete:

- Return to the spreadsheet -> type nv:

- Press Enter -> nv automatically turns into Employee:

- In case you want to type the normal nv word that is not a substitute for the phrase Staff perform the following: Go back to File -> Option -> Proofing -> AutoCorrect -> AutoCorrect English dialog box appears -> select phrases Words to delete -> Delete:

After deleting the abbreviation, go back to the worksheet and type nv, press Enter -> result:

- However, you should use the AutoText feature that Excel supports available to be proactive in using phrases instead of content or not.

The above is a detailed guide on how to set up the AutoCorrect function in Excel 2013.

Good luck!