drop down

[anita]

Does anyone know how to create a drop-down menu in Excel?
For example in Cell A1 I want there to be a list that I
can choose from.

 

[Andy Wiggins]

Check out Data Validation on the Data menu

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"