Quickly Entering Long Names
Do you find yourself repeatedly typing long names such as client names, place names, part names, etc... in your workbooks? You may have wished for a way to avoid retyping those name every time.
Sometimes Excel will guess and suggest some of the names as you begin to type the first few letters (if Excel's AutoComplete option hasn't been turned off). The problem with AutoComplete is, when there are similar names, you may find that you still have to type most of the name before Excel figures out which one you are typing.
I'd like to show you a trick that will allow you to enter these long names much faster by typing just an abbreviation. We will accomplish this with the help of Excel's AutoCorrect feature. We can trick AutoCorrect into replacing our abbreviations with the full names.
If you already have your list of long names in a worksheet, you can save some time, in step 4 above, by copying them (CTRL+C) individually and pasting them (CTRL+V) in the 'With' text box.