Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection.
Other videos in this course
This video is part of a training course called Create and manage drop-down lists. You can download the entire course or watch the videos online:
- Video: Drop-down lists. (You are here!) Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection.
- Video: Drop-down list settings. You can use a comma-delimited list, a cell range, or a named range to define the options in a drop-down list. This video focuses on how to use a cell range and named range.
- Video: Input and error messages. To help people decide what drop-down list option to select, and even to let them know that a cell contains a drop-down list, you can create a message that appears when they select a cell. Or that shows an error message when a drop-down list option isn't selected properly.
- Video: Manage drop-down lists. To prevent changes to your drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data. And unhide them if you need to make changes. You can also lock and password protect the cells on the worksheet or even the entire worksheet.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.