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

Share this & earn $10
Excel Campus - Jon
Published at : 08 Jan 2021
1095918 views
9483
205

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: https://www.excelcampus.com/tips/data-validation-drop-down-list/

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: https://www.excelcampus.com/vba/search-data-validation-drop-down-lists/

Other Videos and Resources:

- How to create Dynamic drop-down lists: https://youtu.be/RLLdY37YUgs
- How to search drop-down lists: https://youtu.be/kntHn2J7pdk
- Update to List Search Add-in: https://youtu.be/igPO79uYoGg
- Dependent Cascading Drop Down Lists: https://www.excelcampus.com/tables/dependent-drop-lists/
excelexcel campusexcel drop down list

Exploring The Most Haunted Place in the World! (100 People DlED)

Exploring The Most Haunted Place in the World! (100 People DlED)

Jim Reeves - Four Walls - Tennessee Waltz - He'll Have To Go

Jim Reeves - Four Walls - Tennessee Waltz - He'll Have To Go

[SFM FNAF] The Misunderstanding by Arshia KaRiKaToR

[SFM FNAF] The Misunderstanding by Arshia KaRiKaToR

A superbly finished 4bedroom Detarched duplex with a bq@lekki phase  1

A superbly finished 4bedroom Detarched duplex with a bq@lekki phase 1

As Long As You Love Me | Cuplikan EP13 Menjadi Sangat Licik | 爱情的开关 | WeTV 【INDO SUB】

As Long As You Love Me | Cuplikan EP13 Menjadi Sangat Licik | 爱情的开关 | WeTV 【INDO SUB】

water wheel generator

water wheel generator

Convenience stores get more convenient

Convenience stores get more convenient

Практика #26 CAN, COULD, (BE) ABLE TO, MANAGED TO - "могу" | Модальные глаголы в английском

Практика #26 CAN, COULD, (BE) ABLE TO, MANAGED TO - "могу" | Модальные глаголы в английском

Cher - Welcome to Burlesque (Official Music Video) | From 'Burlesque' (2010)

Cher - Welcome to Burlesque (Official Music Video) | From 'Burlesque' (2010)

Researchers develop gait test for early autism

Researchers develop gait test for early autism

Why the Narcissist Wants You Dead

Why the Narcissist Wants You Dead

Why You Keep Failing

Why You Keep Failing

Said The Sky x Dabin - Superstar (feat. Linn)

Said The Sky x Dabin - Superstar (feat. Linn)

7M: Who's Most Likely

7M: Who's Most Likely

5 Iced Starbucks Drinks You Can Make at HOME

5 Iced Starbucks Drinks You Can Make at HOME

'Will' or 'Going to' - Talking about Future plans - (English Grammar Lesson)

'Will' or 'Going to' - Talking about Future plans - (English Grammar Lesson)

I Have other Plans in Life | Briefly Cartoons

I Have other Plans in Life | Briefly Cartoons

Our first drive in the Caddy didn't go according to plan.

Our first drive in the Caddy didn't go according to plan.

Special Bulletin (1983)

Special Bulletin (1983)

Field of Vision - This is an Address (Audio Description)

Field of Vision - This is an Address (Audio Description)

❤️MaxTul❤️ How closed are you guys?!

❤️MaxTul❤️ How closed are you guys?!

Gorgon City - Get Together (Official Audio)

Gorgon City - Get Together (Official Audio)

We Asked Korea’s Top Virus Expert Why COVID-19 Is Getting Worse | STAY CURIOUS #32

We Asked Korea’s Top Virus Expert Why COVID-19 Is Getting Worse | STAY CURIOUS #32

can be, will be 를 세상에서 제일 쉽게 설명합니다. _ 다시 배우는 영어 회화와 문법 #49 (친절한 대학 정주행 314편)

can be, will be 를 세상에서 제일 쉽게 설명합니다. _ 다시 배우는 영어 회화와 문법 #49 (친절한 대학 정주행 314편)

Urbanlogue S02E01: Public Transport SOP's to ensure the health and safety of crew and passengers

Urbanlogue S02E01: Public Transport SOP's to ensure the health and safety of crew and passengers

The Guts - Slipped Disco

The Guts - Slipped Disco

Fun Facts about the Colleges at the University of Toronto

Fun Facts about the Colleges at the University of Toronto

One Direction Iconic Moments that you probably have seen a thousand times before pt.1

One Direction Iconic Moments that you probably have seen a thousand times before pt.1

Ultimate Fountain Challenge #4

Ultimate Fountain Challenge #4

Requests (formal & informal) - May I? & Can you? + appliances | Mark Kulek - ESL

Requests (formal & informal) - May I? & Can you? + appliances | Mark Kulek - ESL

ASMR SPICY SEAFOOD and MUSHROOM (OCTOPUS, SCALLOP, ABALONE, SHRIMP, ENOKI MUSHROOM) MUKBANG

ASMR SPICY SEAFOOD and MUSHROOM (OCTOPUS, SCALLOP, ABALONE, SHRIMP, ENOKI MUSHROOM) MUKBANG

Sheikhs Sudais Launches A New Robot 🤗 Will be  used for startling Masjid Al Haram❤ deeni duniya a

Sheikhs Sudais Launches A New Robot 🤗 Will be used for startling Masjid Al Haram❤ deeni duniya a

Crystal Gayle A Long and Lasting Love Official Vi   360P

Crystal Gayle A Long and Lasting Love Official Vi 360P

Chapter 1 | SIGNIFICANCE  OF THE STUDY paano gumawa?

Chapter 1 | SIGNIFICANCE OF THE STUDY paano gumawa?

Creative Ways to AUTO SORT Your Items | Bedrock Guide 023 | Survival Tutorial Lets Play

Creative Ways to AUTO SORT Your Items | Bedrock Guide 023 | Survival Tutorial Lets Play

Clauses and Kinds of Clauses (Part 1)

Clauses and Kinds of Clauses (Part 1)

15 Earth Like Exoplanets that May Support Life

15 Earth Like Exoplanets that May Support Life

Benjamin Clementine - I Won’t Complain (Official Video)

Benjamin Clementine - I Won’t Complain (Official Video)

Rep. Clyburn: Buttigieg Being Gay Is an Issue for Older Black Voters

Rep. Clyburn: Buttigieg Being Gay Is an Issue for Older Black Voters

Somatoform Disorders (Somatic Symptom, Conversion, Illness Anxiety, Factitious, Malingering)

Somatoform Disorders (Somatic Symptom, Conversion, Illness Anxiety, Factitious, Malingering)

furthermore and moreover

furthermore and moreover

Spice - Inches | Official Music Video | Reggae Gold 2020 Exclusive

Spice - Inches | Official Music Video | Reggae Gold 2020 Exclusive

Talk and Mock Naresh Kumar Sir wishes for our anniversary | 1st time in our Channel | Talk and Mock

Talk and Mock Naresh Kumar Sir wishes for our anniversary | 1st time in our Channel | Talk and Mock

Smartest Man Alive Experiment! - Part 1

Smartest Man Alive Experiment! - Part 1

Learn 5 Contemporary/Lyrical Jazz Moves with me!

Learn 5 Contemporary/Lyrical Jazz Moves with me!

ROCKY Filming Locations YOU’VE NEVER SEEN BEFORE in 2020 and some DESTROYED - Philadelphia

ROCKY Filming Locations YOU’VE NEVER SEEN BEFORE in 2020 and some DESTROYED - Philadelphia

My Body Is Completely Covered In Hair And I Never Shave!

My Body Is Completely Covered In Hair And I Never Shave!

10 TIPS ON HOW TO MAKE A SMALL SPACE LOOK LARGER | MAKE YOUR ROOM LOOK BIGGER | INTERIOR DESIGN

10 TIPS ON HOW TO MAKE A SMALL SPACE LOOK LARGER | MAKE YOUR ROOM LOOK BIGGER | INTERIOR DESIGN

First Vlog Of The Year, Sorting Out The House // VLOG

First Vlog Of The Year, Sorting Out The House // VLOG