pulldown boxes
"Data" - "Validation"
Under Allow pick "List" In the Source Type "Yes, No" (without quotes) Uncheck the "Ignore Blank" checkbox Hit OK You can also populate it with a list from your sheet by entering a range in the "Source" field. Dan E "david" wrote in message ... I was wondering if it was possible to make a pulldown in a cell. So, that I could make them select from the pulldown menu choices. For example in a certain cell, I just want them to select yes or no. Thanks for you help, David |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com