|
TheExcelAddict.com
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 an
list of all previous entries in that column. Just
use the arrow keys to select an item and press Enter.
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 TheExcelAddict.com/Newsletter.htm 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
|