Drop down list

  • Thread starter Asoka Walpitagama - Brandix College IT
  • 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
 
A

Andrea Jones

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top