MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

Thanks Steve, I'll try this out today.