Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Drop Down list in Excel

Posted by Tony Q on February 06, 2002 8:36 AM

Is there a way to create a Drop Down list..simular to the list one can create in WORD when dealing with forms?

Re: Drop Down list in Excel

Posted by Tim on February 06, 2002 12:49 PM

Use Data, Validation, Allow from: List.

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.