Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |