drop down menus

[Russell]

Does anyone know how to insert drop down menus in a
worksheet. It is for a fact gathering programme I am
trying to write. eg. Enter Title - (Mr, Miss, Mrs, Dr,
Rev)and you enter the first inital or press down cursor.

Thanks guys for assistance

 

[Ken Wright]

Pick a cell, do data / validation / list / Type Mr,Mrs,Dr etc Hit OK and you
are done.

 

[Guest]

Many thanks

-----Original Message-----
Pick a cell, do data / validation / list / Type Mr,Mrs,Dr etc Hit OK and you
are done.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------- -------------------
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------- -------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003


.