How to create a drop down menu


Posted by marilyn on March 13, 2001 4:06 AM

Please help,
How do you create a drop down menu in excel?

Posted by steve on March 13, 2001 6:25 PM

Hi marilyn,

What you want to do is select data, choose validation and select list in the allow box, make sure the in-cell drop down box is selected and then use the source box to select the data you want is the list. You can either type it in the source box or link it to data on the page.

let me know if you need any more help

steve



Posted by Marilyn on March 14, 2001 2:58 AM

Thanks Steve, I'll try this out today.
Marilyn