Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create multi choice selec drop down list in Excel please
In Excel I need to set up a drop down list from which I can select multiple
choices please. Eg. select multiple locations from a list of locations. UREGENT Thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create multi choice selec drop down list in Excel please
Hi Jilly
In XL2002 (XP) do the following: Select the cell in which you want the drop down Click on Data | Validation From the 'Allow' box select 'List' Type in your values in the Source box seperated with a comma (e.g. Item 1, Item 2, Item 3) Click 'OK' Note: You can also enter Named Ranges into the Source box Regards Trevor "JillyB" wrote: In Excel I need to set up a drop down list from which I can select multiple choices please. Eg. select multiple locations from a list of locations. UREGENT Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create multi choice selec drop down list in Excel please | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Multi-select from drop down list in Excel 97 | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
How do i create a multiple choice drop down list | Charts and Charting in Excel |