Microsoft Office Tutorials and References
In Depth Information
Letting Excel help with typing chores
AutoComplete matches only exact cell entries, not individual words in a cell. For example,
if you begin typing John in column A of the worksheet, AutoCorrect doesn’t intervene
because it is not an exact match for any existing entry. Wisely, AutoComplete does not
work when you’re editing formulas.
Instead of typing, you can right-click a cell and click Pick From Drop-Down List on the
shortcut menu to select an entry from the same column, as shown in Figure 8-45. After
Excel displays the list, click the entry you want, and Excel enters it in the cell. Of course, you
can’t add new entries this way, as we did in Figure 8-44; only existing entries in the same
column are available in the list.
Figure 8-45 Right-click the cell directly below a list, and click Pick From Drop-Down List to
display a list of unique entries in the column.
INSIDE OUT Create your own typing shorthand
You can use AutoCorrect to monitor your own common typing errors and create
your own typing shortcuts. Click the File tab, Options, and then click the AutoCorrect
Options button in the Proofing category. Add your shorthand entries to the Replace
Text As You Type area on the AutoCorrect tab. (Figure 8-42 shows the AutoCorrect tab
in the AutoCorrect dialog box.) Type the characters you want to use as the shorthand
“code” in the Replace box, type the characters with which you want to replace them in
the With box, and finally click Add. For example, you can type MS in the Replace box
and then type Microsoft Corporation in the With box. Thereafter, each time you type
MS, Excel replaces it with the words Microsoft Corporation . Be sure you choose unique
codes; otherwise, Excel might apply AutoCorrect to entries you don’t want changed.