Create and manage drop-down lists in Excel 2013

Drop-down lists simplify working with Excel worksheets by limiting the type of data entries people can make in a cell. In this course you will learn how to create, use, and manage drop-down lists. To access the course, click here.

This course consists of the following videos:

Drop-down lists
Learn how to create a drop-down list to limit the type of data options people can enter within a cell. (Length: 1:01)

Drop-down list settings
Find out how to define the following options in a drop-down list:
  • Cell range
  • Named range (Length: 4:37)

Input and error messages

Discover how to:
  • Create a message notifying people that a cell contains a drop-down list.
  • Create a drop-down list that helps people with option selection or shows an error message when a drop-down list option is improperly selected. (Length: 2:47)
Manage drop-down lists
Learn how to perform the following actions:
  • Prevent changes to drop-down list data by hiding columns, rows, or the entire worksheet.
  • Make hidden columns reappear if you need to make changes.
  • Lock and password protect worksheet cells or an entire worksheet. (Length: 6:20)
This summaryprovides a brief reminder of the key points in this course.

To begin:

Download this tutorial. Click Enable Editing in the message bar.

Enable Editing

Then press F5 or click Slide Show>From Beginning to start the course. If the videos in this course don’t play, you may need to download QuickTime or just switch to PowerPoint 2013.

Article ID: 2949863 - Last Review: 28 Mar 2014 - Revision: 1