The Little-Known, Seldom-Used AutoComplete TrickIf you're like me, it didn't take long after starting to use Excel to wonder if there is an easier way to repeat data in a column that you already have entered in previous cells in that column. The natural response is to copy and paste. But often that involves scrolling up the sheet to copy the data from previous cells and then scrolling back down to paste it.
Wouldn't it be great if you could just select an item previously used in that column from a list and have it automatically entered for you? Wouldn't that be cool?
Well you can!
Any time you want to repeat data that is already in a column,
simply press ALT+DOWN ARROW. Just like magic, you've got a
list of all previous entries in that column. Just
use the arrow keys to select an item and press Enter.
right click a blank cell immediately below the last item in the column
and select Pick from Dropdow List... and choose an item to enter in the
share it with your friends and associates?