Microsoft Excel 'Quick Tip'

The Little-Known, Seldom-Used AutoComplete Trick

If 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.

Alternatively,  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 cell.

Way cool!

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".

Subscribe at the and you could win a really cool prize.

You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright All Rights Reserved by

Close this window