Would you like your web hosting company to PAY YOU?

TheExcelAddict.com
Microsoft Excel "Quick Tips"

Save Time By Quickly Duplicating Data Values

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.



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 t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright 2002 All Rights Reserved by FJH Marketing

Close this window