Set the AutoCorrect function in Excel

The following article gives detailed instructions for you to set up the AutoCorrect function in Excel.

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!