View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary
 
Posts: n/a
Default validation - anyway to select multiple choices in the pull down?

1. Create the list somewhere in the sheet.
2. Select the range you where you want the drop down.
3. Go to Data/Validation...Select 'List' from the Drop Down.
4. Enter the source (where you have created the list) in the source box. (or
simply select the range by clicking on the button next to source box.)
5. Now, you can hide the range where you have created the list.

Is this what you want?

Gary


"TracyChoi" wrote in message
...
I am looking way in Excel to create a pull down list which allows multiple
choices from the list to be made. Any ideas?