|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright ©2010
All rights reserved.
Search Contextures Sites
Excel Video Tutorials -- Data Validation Basics
Excel Data Validation - Create Drop Down List
Excel Data Validation - Drop Down Arrows Missing
Excel Data Validation - Show a Message to Users
Excel Data Validation - Three Types of Drop Down ListsExcel Data Validation - Create Drop Down List
Create an Excel Data Validation 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 data validatio drop down list, see Excel Data Validation - Basics.
Excel Data Validation - Drop Down Arrows Missing
When you click on a cell that has a data validation 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 Excel tutorial video will help you troubleshoot the problem. For written instructions, see Data Validation Drop Down Arrows Not Visible
Excel Data Validation - Show a Message to Users
With Excel data validation, you 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 Excel Data Validation Messages to Help Users.
Excel Data Validation - Three Types of Drop Down Lists
In addition to data validation drop down lists, you can create other types of drop down lists on an Excel worksheet. This Excel video tutorial 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
Contextures Inc., Copyright ©2010
All rights reserved.
Last updated: August 19, 2010 6:48 PM
