A subscriber wrote to me last week asking why there isn’t an AutoComplete feature in MS Excel.
Well it’s not exactly AutoComplete but it will do the trick for you. Follow the steps below to learn how:
Whenever you want to repeat data that already appears in a column, simply click:
- ALT + Down Arrow
Quick as a flash you have a list of all previous entries in that column!
Use the arrow keys to select an item and click on Enter.
Pretty cool huh?