View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I create multi choice selec drop down list in Excel please

DataValidationList.

You can type the values in comma-delimited or use a pre-existing range of cells
in a column with the values.

Note: if using a pre-existing range, if you give that range a name, the list
can be on another worksheet.


Gord Dibben MS Excel MVP

On Mon, 3 Mar 2008 06:37:01 -0800, JillyB
wrote:

I urgently need to create a drop down list in excel with multiple choice
selections - is this possible please? How do I do it .

Thanks