List boxes in MSExcel2000
I'm trying to create a workbook that includes drop-down
lists. I've looked around in the Helpfile but can't find how to create a drop-down list in a cell. Does anyone know ow to do this? Please help. Thanks, ergeordie |
List boxes in MSExcel2000
Under the Data menu, look at Validation. Under validation, choose the list
option. -- Regards, Tom Ogilvy "ergeordie" wrote in message ... I'm trying to create a workbook that includes drop-down lists. I've looked around in the Helpfile but can't find how to create a drop-down list in a cell. Does anyone know ow to do this? Please help. Thanks, ergeordie |
List boxes in MSExcel2000
Goerdie,
Check out Debra Dalgleish's site on Data Validation at http://www.contextures.com/xlDataVal01.html, explanations and solutions -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ergeordie" wrote in message ... I'm trying to create a workbook that includes drop-down lists. I've looked around in the Helpfile but can't find how to create a drop-down list in a cell. Does anyone know ow to do this? Please help. Thanks, ergeordie |
List boxes in MSExcel2000
Thanks for the information. It works perfectly.
ergeordie -----Original Message----- Goerdie, Check out Debra Dalgleish's site on Data Validation at http://www.contextures.com/xlDataVal01.html, explanations and solutions -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ergeordie" wrote in message ... I'm trying to create a workbook that includes drop-down lists. I've looked around in the Helpfile but can't find how to create a drop-down list in a cell. Does anyone know ow to do this? Please help. Thanks, ergeordie . |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com