How to make a drop down menu in Excel 2007

Learn how to create a drop down menu in Microsoft Excel 2007

Don't forget to check out our site howtech.tv/ for more free how-to videos!
youtube.com/ithowtovids - our feed
facebook.com/howtechtv - join us on facebook
plus.google.com/103440382717658277879 - our group in Google+

In this video tutorial we will show you how to make a drop down menu in Excel 2007.

In order to create a drop-down menu, open the Microsoft Excel 2007. Edit your cells on "sheet1", for example "Car", "Year", "Price". After that, go to "Sheet2". Add a list of "Car" names. Then select all cells with the car names.

Change "a1" to "car" in the "name box". Now go back to "sheet1". Select the empty cells under your "Car" column. Go to the "Data" tab. Click on "Data Validation" and choose "Data validation".

In the appeared window set validation criteria to "List".

In the "source", type "=Car" and press "ok".

Now you have created a drop down menu and can use it in your excel cells.