Search
Contextures Sites
| |||
|
|
|
|||
Contextures Inc., Copyright ©2013
All rights reserved.
Search Contextures Sites
Data Validation Videos
Create Drop Down List in Excel 2010
Create Drop Down List in Excel 2003
Drop Down Arrows Missing
Show a Message to Users
Three Types of Drop Down ListsCreate a Drop Down List in Excel 2010
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 in Excel 2003
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.
Drop Down Arrows Missing
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
Show a Data Validation Message to Users
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.
Three Types of Drop Down Lists
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
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 21, 2013 7:07 PM
