How to Create a Dependent Drop-Down List in Excel (Cascading)
Pick a country and the city list narrows to just that country's cities — a cascading drop-down. The manual method is a maze of named ranges and INDIRECT that breaks on spaces. Here's the one-click way that builds the whole cascade for you.
Last updated: August 2026
| Pick Category | Item list filters to… | |
|---|---|---|
| USA | → | New York, Boston |
| UK | → | London, Manchester |
Why the manual method is fiddly
The textbook approach: make one named range for the categories, then one named range per category holding its items, then a data-validation list whose source is =INDIRECT(A2) so the child list follows the parent cell. It works — until a category has a space (named ranges can't contain spaces, so "New York" breaks it), and it's a lot of setup. The modern =FILTER() shortcut is cleaner but Excel 365 only.
The 1-click way — Tellsheet's Dependent Drop-downs
Select your two-column Category → Item list and run Dependent Drop-downs. It builds the category list and each category's item list as named ranges on a new Drop-downs sheet, and drops in a live demo: pick a category and the item drop-down beside it filters to just that category's items. Because it names the lists by position and resolves the child with MATCH, categories with spaces, slashes, or accents all work — no 365 required. Pairs with Validate Data and Extract Unique Values.
Frequently asked questions
How does one drop-down depend on another?
The child list filters by the parent's value. Dependent Drop-downs builds the lists and wires that cascade for you.
Do categories with spaces work?
Yes — unlike the classic INDIRECT method, it handles spaces, slashes, and accents.
Do I need Excel 365?
No — it uses data-validation lists + named ranges, not the 365-only FILTER.
Where does it put everything?
On a new "Drop-downs" sheet with the lists and a working demo you can copy anywhere.
Related Excel guides
Build a cascading drop-down in one click
Dependent Drop-downs turns a Category → Item list into working cascading lists — spaces and all, no 365 needed.
Get Tellsheet free See pricing