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
 

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

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filtered drop down list 2
drop-down menu disappeared 6
Drop Down List Contains the List Header Row 1
How to delete a drop down box in Excel 2007 1
Right-click Drop down list 1
drop downs showing down arrow 4
Creating drop downs in a cell contingent on another drop down 1

Back
Top