Here is the thing. Every day I need to type in the goods type so many like "AB220", "AC230" and so on. So I don't want to input that so many time. So I want to use the abbrev to make that. For example I just type the "2", "2" and "enter" the cell will show the AB220.
I know that there is a mechanism in the Excel that if you enter "AB" the AB220 will show out. But that need to input the head character of a word, which not meet my requirement. So how to fix that ?
Bookmarks