Contextures

Excel Data Validation Basics Videos

Excel video tutorials for Excel data validation basics. Add a drop down list in cell, fix missing arrows, show message

Create a Drop Down List in Excel

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

More Videos

Data Validation

Excel Videos Index

Mouse Shortcuts

Names

Search Contextures Sites

 

 

 

 

Excel Data Entry Popup List

 

Last updated: January 1, 2017 1:13 PM
Contextures RSS Feed