November 26, 2012 |

Taking Control of Repetitive Text in Excel

This would suit the situation where you find yourself keying in lots of data and then want to re-use text without retyping it; perhaps it didn’t appear as an AutoComplete, or you do not want to begin typing the item to activate AutoComplete.

These instructions also assume you have a list of text above your insert point and no empty cell above you (or it doesn’t work).

1.  Hold down the Alt key and then press the down cursor arrow.
2.  You’ll find that a drop down list of the text already entered into the column will appear.

3.  Let go of the Alt key and use the cursor down arrow key to move through the list to stop on the one you want, or just mouse click on it.