How do you create a drop down menu ?

coneyglaze · Apr 26th, 2002, 09:33 AM

I have a work sheet and in a column I have a header of Type of Accident.
In the cell below that I want to create a drop down menu with the two choices of Fleet or Personel so that the user only has that to choose from..

Thanks
Coneyglaze

Steve Hartman · Apr 26th, 2002, 09:40 AM

clcik the cell you want the drop down in, then click DATA > VALAIDATION. On the settings tab chose list for ALLOW: and then type in Fleet,Personal in the SOURCE:

coneyglaze · Apr 26th, 2002, 10:04 AM

coneyglaze · Apr 26th, 2002, 10:06 AM

Steve that is what I was looking for... and I was sure to type in Personal not Personel Thanks...........

Coneyglaze

rmtaylor · Apr 27th, 2002, 06:33 PM

Drop down validated lists tip
Here is the real tip : Generally, when you try to set up a data validation and you enter a list that is on another sheet, for example if you enter "=Sheet2!A1:A99", you will get an error saying that "You may not use references to other worksheets for data validation criteria". There is a way around this limitation! Go to Sheet2, highlight your list range and give it a name with Insert - Names - Define. If you assign A1:A99 on Sheet2 the range name of MyList (or anything you can remember). Then go to your original sheet, and in the Data Validation dialog, for the List, enter =MyList and you will be able to have the validations on another worksheet.

Ivan F Moala · Apr 27th, 2002, 09:00 PM

Quote:

On 2002-04-27 17:33, rmtaylor wrote:
Drop down validated lists tip
Here is the real tip : Generally, when you try to set up a data validation and you enter a list that is on another sheet, for example if you enter "=Sheet2!A1:A99", you will get an error saying that "You may not use references to other worksheets for data validation criteria". There is a way around this limitation! Go to Sheet2, highlight your list range and give it a name with Insert - Names - Define. If you assign A1:A99 on Sheet2 the range name of MyList (or anything you can remember). Then go to your original sheet, and in the Data Validation dialog, for the List, enter =MyList and you will be able to have the validations on another worksheet.

You can Also have the list defined from another workbook sheet.
Only problem is the workbook needs to be Open

eg. ='[DataValidation List Link.xls]List'!$A$1:$A$18

In your Defined names list for MyList.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 09:33 AM	#1
coneyglaze New Member Join Date: Apr 2002 Location: Fort Worth Posts: 13	I have a work sheet and in a column I have a header of Type of Accident. In the cell below that I want to create a drop down menu with the two choices of Fleet or Personel so that the user only has that to choose from.. Thanks Coneyglaze

Apr 26th, 2002, 09:40 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	clcik the cell you want the drop down in, then click DATA > VALAIDATION. On the settings tab chose list for ALLOW: and then type in Fleet,Personal in the SOURCE:

Apr 26th, 2002, 10:04 AM	#3
coneyglaze New Member Join Date: Apr 2002 Location: Fort Worth Posts: 13

Apr 26th, 2002, 10:06 AM	#4
coneyglaze New Member Join Date: Apr 2002 Location: Fort Worth Posts: 13	Steve that is what I was looking for... and I was sure to type in Personal not Personel Thanks........... Coneyglaze

Apr 27th, 2002, 06:33 PM	#5
rmtaylor Board Regular Join Date: Feb 2002 Location: Scotland Posts: 139	Drop down validated lists tip Here is the real tip : Generally, when you try to set up a data validation and you enter a list that is on another sheet, for example if you enter "=Sheet2!A1:A99", you will get an error saying that "You may not use references to other worksheets for data validation criteria". There is a way around this limitation! Go to Sheet2, highlight your list range and give it a name with Insert - Names - Define. If you assign A1:A99 on Sheet2 the range name of MyList (or anything you can remember). Then go to your original sheet, and in the Data Validation dialog, for the List, enter =MyList and you will be able to have the validations on another worksheet.