MrExcel Publishing
Your One Stop for Excel Tips & Solutions

drop down list

Posted by Jennifer on December 20, 2000 2:50 PM

Hi--I want to create a feature in excel, and I'm not sure what to do. I'm creating a column named "Salesperson", and want a drop-down list with options (something that looks like a menu). The user could then click on the cell and choose from the list, rather than typing in a different salesperson for each cell in the column.Can you help me? :)

Posted by lenze on December 20, 2000 3:09 PM

Posted by lenze on December 20, 2000 3:11 PM

Sorry about above; Hit wrong button
Anyway, use the list feature under Data,Validation