Excel Dynamic Dropdowns with INDIRECT (Auto‑Updating Lists)

Tired of dropdowns that don’t update when your data changes? In this video, I’ll show you how to create dynamic dropdowns in Excel using tables and the INDIRECT function. Format your list with CTRL + T, name the table, and link it in Data Validation. Now, your dropdown updates automatically whenever new items are added. Clean, simple, and professional—perfect for smarter spreadsheets.

Видео Excel Dynamic Dropdowns with INDIRECT (Auto‑Updating Lists) канала Data by Jundi