This tutorial demonstrates how to create a drown-down list in Excel using data validation.

Download Microsoft Excel Now

In this video, we are creating a simple HR employee hire form and limiting the user to selecting numeric months and years from a drop-down list on a separate tab. The tab can be hidden from the workbook once the form is complete so the user cannot alter the data.

The tutorial was done in Microsoft Excel 2010, but the function will be similar in previous versions.

Video was made using Cam Studio (http://camstudio.org).

Learn Everything There is to Know About Microsoft Excel

Advertisements