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!
You should read it
- Shortcut guide, abbreviated in Excel
- Backup AutoCorrect in Microsoft Office
- Typing, abbreviation in Word, Excel with AutoCorrect
- Basic Excel functions that anyone must know
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- How to use the LEN function in Excel
- How to use COUNTIF function on Excel
- How to use the MOD function and QUOTIENT function in Excel
- How to use MID functions to get strings in Excel
- How to use Excel's VALUE function
- How to use the WRAPROWS function in Excel
May be interested
How to protect spreadsheets in Excel
How to insert and delete worksheets in Excel
How to choose images as a background for a spreadsheet in Excel
How to change the SheetTab color and hide the worksheet in Excel
How to rename, copy and move spreadsheets in Excel
Overview of the interface in Excel 2013, 2016