My recomendations

Tuesday, December 30, 2014

How to create a drop down menu in excel 2010



Place Cursor into Cell where you desire the drop down menu (See Highlighted area).




 

  • Data à Data Validation à From the drop down menu, select Data Validation.



  


  • Setting Tab à Allow àList



 


  • Source à Click the red arrow à Go to page where the information is stored, select the information you would like to appear in the drop down menu.



 


  • Click Red Arrow à Select OK


 




  • And there you have it, a quick and simple drop down menu.