Video Tutorial: How to Create a Drop Down List in Excel Using Data Validation

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

One comment

What do you think?

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s