Drop down list

  • Thread starter Thread starter Asoka Walpitagama - Brandix College IT
  • Start date Start date
A

Asoka Walpitagama - Brandix College IT

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
 
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
 
Sorry..., in my eyes it is a matter of terminology + my bad understanding of
English.
One [like me] could think that the list will be operational only if there
are, already, repetitive values.
Micky
 
Back
Top