If you are completing a column with items that repeat themselves then you can
quickly fill in the next entry in that column by selecting it from an
automatic list of what's been entered in that column already. Press Alt +
down cursor arrow to see the available list (you may want to make the column
wider). See http://www.allaboutoffice.co.uk/expick.htm for more information.

Andrea Jones
www.stratatraining.co.uk

"Asoka Walpitagama - Brandix College IT" wrote:

When right clicked on a cell there appears an option called 'pick from drop
down list',. How to use this feature & does it have any relationship to Data
validation drop down list