A subscriber wrote to me last week asking why there isn’t an AutoComplete feature in MS Excel.
My reply:
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?