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!