Create Dependent Drop-down Lists in Excel - Easy Method

Create Dependent Drop-down Lists in Excel - Easy Method

Kevin Stratvert via YouTube Direct link

Introduction

1 of 10

1 of 10

Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Create Dependent Drop-down Lists in Excel - Easy Method

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Introduction
  2. 2 Download the workbook
  3. 3 Background
  4. 4 Set up a named range
  5. 5 Set up first dropdown list
  6. 6 Create dependent dropdown lists
  7. 7 Troubleshoot named ranges
  8. 8 Testing the Dropdowns
  9. 9 Copy dropdowns to multiple rows
  10. 10 Wrap up

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.