Search Contextures Sites
Data Validation Videos
To create a drop down list in Excel 2010, you can name a list of items, based on a named Excel table. Then, use that list as the source for the Data Validation drop down list.
Watch the steps in this short video tutorial, and for written instructions on how to create a drop down list, see Excel Data Validation - Basics.
Create a drop down list to help users enter data, and to prevent typing errors and invalid entries on the worksheet.
For written instructions on how to create a drop down list, see Excel Data Validation - Basics.
When you click on a cell that has a drop down list, an arrow appears at the right side of the cell. Click that arrow to see the list of valid items for data entry in that cell.
However, occasionally those drop down arrows don't appear, and this video will help you troubleshoot the problem. For written instructions, see Drop Down Arrows Not Visible
With data validation, you can show a message automatically, as soon as a cell is selected. These messages can help users with data entry, by advising them about what types of values are allowed in the selected cell.
For written instructions see Data Validation Messages to Help Users.
In addition to data validation drop down lists, you can create other types of drop down lists on a worksheet. This video shows the 3 types of drop down lists available. For written details, see the Contextures Blog post: 3 Types of Excel Drop Down Lists Compared
Excel Video Tutorials - Data Validation
Excel Video Tutorials - Data Validation Basics
Excel Video Tutorials 01
Excel Video Tutorials 02
Excel Video Tutorials 03
Excel Video Tutorials 04
Excel Video Tutorials 05
Excel Video Tutorials 06
Excel Video Tutorials 07
Excel Video Tutorials 08
Excel Video Tutorials 09
Excel Video Tutorials 10
Excel Video Tutorials 11
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 21, 2013 7:07 PM