Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Excel: Creating Drop-Down Lists

via LinkedIn Learning


Learn how to save time and ensure more accurate data by creating drop-down lists in Excel.

By including drop-down lists in an Excel spreadsheet, you can simplify work for yourself and your team and ensure that data is entered accurately. Many people assume that it takes advanced know-how to create drop-down lists in Excel—but they're actually simple to create. In this quick course, Excel expert Chris "Smitty" Smith shows how to quickly and easily work with drop-down lists. Smitty walks through organizing your list data, creating the drop-down list, and responding to any error messages you might encounter along the way.


  • Welcome
1. Drop-Down List Concepts
  • Drop-down list concepts
2. Set Up a Drop-Down List
  • Step one: Prepare drop-down list data
  • Step two: Create your drop-down list
  • Step three: Input and error messages
3. Use Drop-Downs to Drive Other Actions
  • Real-world examples
  • Use drop-down lists with VLOOKUP
4. Reuse a Drop-Down List
  • Extend or delete a drop-down list
  • Next steps

Taught by

Chris B. Smith

Related Courses


0.0 rating, based on 0 reviews

Start your review of Excel: Creating Drop-Down Lists

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free