HDTutorial
EN
How to Create Drop Down Lists in Cells - The Complete Excel Guide

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Drop Down Lists in Cells - The Complete Excel Guide

1,941,425 views October 26, 2018 12:48

Watch on YouTube
ChannelExcel Campus - Jon

Chapters

Description from the creator

Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/

In this video you will learn how to create drop down lists in cells in Excel. These are also referred to as Data Validation Lists. The drop down lists allow the user to select from a drop-down menu of items and input the value in the cell. Download the practice Excel file: excelcampus.com/tips/data-validation-drop-down-…

Drop-down lists in cells are great for data entry or inputs for interactive financial models.

I explain how to:
- Create the drop down list from a comma separated list.
- Create the drop down list from a range of cells.
- Use keyboard shortcuts to select items from the list.
- Copy or apply the drop down lists to other cells.
- Handle errors and invalid inputs.
- Add new data to the source range and update the list.

Compatibility: Data validation drop-down lists are available in all versions of Excel including Excel 2003, 2007, 2010, 2016, 2019, Office 365 for Windows and Excel 2011, 2016, and beyond for Mac.

The Free List Search Add-in:
Unfortunately we can't directly search the drop down lists within Excel. So I created a free add-in called List Search that allows you to search any drop down list and input the value in the cell.

It's packed with additional time saving features. Click the link below to learn more and download List Search.

Download The List Search Add-in: excelcampus.com/vba/search-data-validation-drop…

Other Videos and Resources:

- How to create Dynamic drop-down lists: youtu.be/RLLdY37YUgs
- How to search drop-down lists: youtu.be/kntHn2J7pdk
- Update to List Search Add-in: youtu.be/igPO79uYoGg
- Dependent Cascading Drop Down Lists: excelcampus.com/tables/dependent-drop-lists/
00:00 Introduction
00:13 How to Create Drop Down Lists in Cells
01:06 How to Create a Drop-down (Data Validation) List
01:25 Drop-down List from Comma Separated Values
01:40 Drop-down List from a Range of Values

About this tutorial

Excel Campus - Jon published this 12:48 video tutorial on October 26, 2018. It has been watched 1,941,425 times on YouTube.

Category
Education
Duration
12:48
Published
October 26, 2018
Views
1,941,425
Likes
15,529

Tags

Share

Further reading

  • Create a drop-down list - Office Support support.microsoft.com

    Create a list of valid entries for the drop-down list, typed on a sheet in a single column or row without blank cells. Select the cells that you want to restrict data entry in. On the Data tab, under Tools , click Data…

  • How to Create Drop Down Lists in Excel - Complete Guide ... excelcampus.com

    We can also use drop-down lists to create interactive reports and financial models, where results change when the user changes a cell’s value. How to Create a Drop-down (Data Validation) List. To create a drop-down list…

  • How to add a drop down list to an Excel cell msn.com

    SEE: How to create a drop-down list in Google Sheets (TechRepublic) You can add the drop down list to multiple Excel cells. Select the range of data input cells (step 2) instead of a single Excel ...

This tutorial in other languages