MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop Down Lists


Posted by Glenn Balian on January 28, 2002 1:37 PM

Please help get me started in creating drop down boxes.
I couldn't find this in "help"
Thanks for the assist


Posted by Michael J. on January 28, 2002 1:43 PM

In A1 to A10 type in your list (e.g. apples, oranges, bananas)

Then click on C1 and go on the menu to DATA, then VALIDATE. Under ALLOW choose LIST. Then in field type $A$1:$A$10. Click OK.

In C1 you now have your drop down list. You can copy and paste the cell anywhere you wish.

Posted by Glenn Balian on January 28, 2002 2:34 PM

Thanks Michael