Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
How do I create a drop donw menu on a spreadsheetPosted by Chris Malone on February 20, 2001 10:18 AM
I want to create a template, and instead of having the person key in information, I want to give them a drop down menu option. After it is created I want to password protect it.
Re: How do I create a drop donw menu on a spreadsheetPosted by steve on February 20, 2001 10:30 PM
The easiest way would be to use data validation. Select data from the menu bar at the top of the screen, select validation. In the allow box, select "list" and make sure the "in-cell dropdown" box is checked. You can then use the reference box to reference it to somewhere on your sheet where the data is located, then lock those cells and protect the sheet.
let me know how it works, steve
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.