Search Contextures Sites
Custom Search

Data Validation Videos

Short video tutorials for Excel Data Validation tips.

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 Lists

Excel Video Tutorials List

Create 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

More Videos

Data Validation

Excel Videos - Index

Mouse Shortcuts

Names

 

More Video Tutorials

Data Validation

Excel Videos - Index

Mouse Shortcuts

Names

 

 

Excel Data Entry Popup List

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 31, 2016 7:29 PM