|
TheExcelAddict.com
Here's one I don't see too many people using. Let's say you are
entering information in a table and many of the entries are
duplicates of previous entries in the same column. You could
save a lot of time if you didn't have to type in every duplicate
value.
Try this. Hold down the ALT key and press the down arrow and you
will be presented with a drop-down list of all previous entries
in that column. Select an item by using the arrow keys and then
press Enter.
share it with your friends and associates?
|