Setting Up AutoCorrect Feature in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article provides a detailed guide on setting up the AutoCorrect feature in Excel.

To set up AutoCorrect in Excel, follow these steps:

Step 1: Navigate to the File -> Options: tab.

Step 2: The Excel Options dialog appears -> Select Proofing -> AutoCorrect Options…

Step 3: The AutoCorrect English dialog appears within the section:

- Replace: Enter the abbreviation.

- With: Enter the content for the abbreviation.

After inputting, click Add to insert the abbreviation into the dialog:

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

- Return to the spreadsheet -> type nv:

- Press Enter -> the abbreviation nv automatically changes to Employee:

- If you want to type 'nv' normally without replacing it with the phrase 'Employee', do the following: Go back to the File -> Option -> Proofing -> AutoCorrect -> AutoCorrect English dialog appears -> select the phrase to remove -> Delete:

After deleting the abbreviation, return to the spreadsheet, type 'nv', then press Enter -> the result:

- However, you should utilize the AutoText feature that Excel provides to be proactive in using replacement phrases for content.

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

Wishing you all success!

Frequently Asked Questions

What are the steps to set up AutoCorrect in Excel?

To set up AutoCorrect in Excel, navigate to File -> Options, then select Proofing and AutoCorrect Options. In the dialog, enter your abbreviation under 'Replace' and the corresponding content under 'With', then click Add.

How can I remove an AutoCorrect abbreviation in Excel?

To remove an AutoCorrect abbreviation in Excel, go to File -> Options, select Proofing, then AutoCorrect Options. Find the abbreviation you want to delete in the AutoCorrect dialog and click Delete, then confirm the change.

Can I use the AutoText feature instead of AutoCorrect in Excel?

Yes, utilizing the AutoText feature in Excel is beneficial for replacing phrases proactively. This allows for efficient content management by inserting frequently used phrases without the need to type them each time.

What happens when I type an abbreviation configured in AutoCorrect?

When you type an abbreviation configured in AutoCorrect and press Enter, Excel automatically replaces it with the designated phrase. For example, typing 'nv' will convert it to 'Employee' if set up correctly.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]