Shortcut guide, abbreviated in Excel

To make it easier for users to edit content, on Word, Excel or other text editing tools, it is possible to type quickly and quickly. In Excel and Word, the shortcut feature is called AutoCorrect.

When the user sets the acronym with the full content, Excel automatically recognizes the word and when you enter the acronym, the complete content is displayed. Thus, with the content of documents appearing many words, we will not need to type many times but just type the acronym for it. The following article will guide you how to type shortcut on Excel.

1. How to create an alternative phrase in Google Docs
2. How to use the shortcut function in Unikey?
3. Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet

Instructions for setting up AutoCorrect Excel

Step 1:

In Excel interface, click on the Office icon above and then click on Excel Options .

Shortcut guide, abbreviated in Excel Picture 1

Step 2:

In the new dialog box interface click on Proofing in the list on the left of the interface and look to the right, click on the AutoCorrrect Options item .

Shortcut guide, abbreviated in Excel Picture 2

Step 3:

The AutoCorrect English dialog box appears. Here, the user proceeds to enter the content you want to turn off. The acronym will enter in the Replace box. The content of the acronym will be written in With . Then click the Add button to save this abbreviation in Excel.

Shortcut guide, abbreviated in Excel Picture 3

You will immediately see the acronym that appears in the table below.

Shortcut guide, abbreviated in Excel Picture 4

Step 4:

Go back to the contents of the Ecxcel table and type the abbreviated abbreviation and press Enter. The full content of the word shortcut will appear.

Shortcut guide, abbreviated in Excel Picture 5

To delete the shortcut that was added to Excel, you also access the AutoCorrect entry in Excel and then click on the abbreviated abbreviation, press Delete.

Shortcut guide, abbreviated in Excel Picture 6

With AutoCorrect feature in Excel, you can shorten the time to enter long words, or appear multiple times in the content. Also, working on Word can use AutoText, also for quick writing or short typing in content.

See more:

1. How to keep Excel and Excel columns fixed?
2. How to temporarily hide rows and columns in Excel 2013
3. Change color between different lines in Microsoft Excel

I wish you all success!