Excel: Creating Drop-Down Lists

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

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