Excel video tutorials for Excel data validation basics. Add a drop down list in cell, fix missing arrows, show message
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
Last updated: January 1, 2017 1:13 PM
Contextures RSS Feed