How to link a drop-down list to a structured table range in Excel 2024?

Опубликовано: 16 Февраль 2025
на канале: Jubitips

306

Set up Excel data validation with structured tables correctly. How to create drop-down arrows in Excel cells? How to connect data validation with a range in Excel? How to use Excel tables as the source for data validation? In this tutorial, I provide answers to these questions and explain the best way to connect Excel data validation with structured tables. The key is the INDIRECT() formula.

0:00 Problem description
0:22 Turn a range into an Excel table
1:16 Syntax for data validation with Excel tables
2:37 Set up data validation

This video has subtitles. Please click [CC] to turn on subtitles, then click [...] and switch to the subtitle that you want.

Buy me coffee: https://www.paypal.com/donate/?hosted...

🔔 Follow me:
Youtube:    / @jubitips
Tiktok:   / jubitips
Facebook:   / jubitips
Instagram: https://instagr.am/iamjubitips
LinkedIn:   / jubitips
Twitter:   / jubitips
Blogger: https://jubitips.blogspot.com
Medium:   / jubitips

#exceltips, #exceltricks, #microsoftexceltips, #microsoftexceltricks

Set up Excel data validation with structured tables correctly