Excel: Creating Drop-Down Lists

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.

Introduction

• 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

Conclusion

• Next steps