Why not print (CTRL+P) this tip and
Microsoft Excel 'Quick Tip'
Quick Data Input Using 'Pick From List' Option
Many times when you input data in your worksheets, the data you
enter at the bottom of a list is often a duplicate of data in the
cells above. To quickly duplicate these entries, right-click on
the empty cell directly below the list and select 'Pick From
List'. You will get an alphabetical list of all entries from the
cells above to choose from.
Much quicker than typing - especially if your typing skills are
anything like mine.
(From a previous tip: Alternatively, you can use ALT+Down Arrow
instead of right-clicking)
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
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