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:

Set the AutoCorrect function in Excel Picture 1

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

Set the AutoCorrect function in Excel Picture 2

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:

Set the AutoCorrect function in Excel Picture 3

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

Set the AutoCorrect function in Excel Picture 4

- Return to the spreadsheet -> type nv:

Set the AutoCorrect function in Excel Picture 5

- Press Enter -> nv automatically turns into Employee:

Set the AutoCorrect function in Excel Picture 6

- 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:

Set the AutoCorrect function in Excel Picture 7

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

Set the AutoCorrect function in Excel Picture 8

- 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!