This short tutorial will show you how to create a drop down menu in Excel. The Drop down menu will allow you to ensure that only the correct data gets entered into a field.
In this example we want to ensure that the end user can only enter the following information into a selection of cells
- On Time
Enter the the options for your drop down menu in cells in your workbook. in Our case we entered them in column M.
Now highlight the cells you want to have the drop down menu in and click Data.
Click data Validation and data validation again
In the box that appears select List
Click into the Source menu box and then highlight the values that you want to be in your drop down menu, in our case M2 to M5. Then click ok
Your Drop down options should now appear:
A full video tutorial ca be found here: