How Excel sets shortcut keys for words

when we use Excel to do the form, we always need to input many times the same words, such as names, units and so on. Input once two times, the feeling is also good, but when more than CTRL + +, you will feel tired. A lot of people would think that if I just typed a few simple initials, the table would automatically appear with the corresponding words. So how does this wish come true? Very simply, let's set the shortcut key for these words together!

First, click the "File" button in the upper-left corner of Excel and click "Options".

In

In the Excel Options window that pops up, click the proofing option, and then click AutoCorrect Options on the right.

The AutoCorrect window that pops up defaults to the AutoCorrect option, to use "BJ" instead of "Beijing", we just need to enter the initials in the input box below "Replace", such as "BJ", enter "Beijing" in the input box under "for", click "Confirm".

This time, we just in the cell, enter "BJ", and then press "enter", "Beijing" will automatically appear in the cell!