Free Excel Tutorial for Engineers : Data Validation

When working on lengthy worksheets, you might have to enter data from a particular list of items. In such cases typing the same thing again and again can be avoided by creating a drop down menu. To create a drop down menu, follow the steps given below:

  1. Select the required cells, go to the data ribbon and click on the data validation option under data validation.

  1. Go to the settings tab in the dialog box and from the drop down menu below Allow select the list option.

  1. Then select the source cells containing the list of items that you want to enter, or type the required options in the space provided separated by commas and click ok.