Amazing Excel Hack: Dependent Dropdowns FAST! #shorts

preview_player
Показать описание
#exceltips #dropdownlist #excelshorts

Hello Friends,

In this video, we have explained how to create a dependent drop-down list in Microsoft Excel. we have used Name Manager to create the multiple names and Data validation with INDIRECT Function.

Subscribe our new YouTube Channel:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store
  1. PK: An Excel Expert
  2. Microsoft Excel
  3. Excel tutorial
  4. dependent dropdown
  5. dropdown list
  6. dynamic dropdown
Рекомендации по теме
Awesome Trick to 0:07:39

Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)

Create Multiple Dependent 0:11:57

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Excel Create Dependent 0:03:50

Excel Create Dependent Drop Down List Tutorial

Smart Dependent Drop-Down 0:15:55

Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

Dynamic Dependent Drop 0:00:52

Dynamic Dependent Drop Down List in Excel | Excel Tips and tricks | #shorts

Excel Tips - 0:03:44

Excel Tips - Best Way to Create Dropdowns that Dynamically Update

Create Dependent Drop 0:12:10

Create Dependent Drop Down List in Excel - EASY METHOD

Reset Dependent Drop-down 0:05:48

Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

Multiple Dependent Drop 0:00:54

Multiple Dependent Drop Down List In Excel! Learn this in one minute! 😎 #excel #exceltips

How to Create 0:09:48

How to Create Multiple Dependent Drop-Down Lists in Excel | Automatically Update with New Values

EXCEL PRO TIP: 0:08:36

EXCEL PRO TIP: Dependent Drop-Downs with INDIRECT

Excel Dependent Drop 0:07:24

Excel Dependent Drop Down List with Tabular Data without Named Ranges

Dynamic Dependent Dropdown 0:29:44

Dynamic Dependent Dropdown Lists in Excel: create and manage all the categories you need - T0032

Excel Dependent Drop 0:08:16

Excel Dependent Drop Downs with FILTER

Dynamic Dependent Dropdown 0:00:59

Dynamic Dependent Dropdown List in Excel

How to add 0:00:20

How to add Dropdown list in Excel? ( In 20 Seconds) | Data Validation trick #shorts #excel

Dependent Drop-Down Lists 0:07:54

Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

Create Multiple Dependent 0:12:02

Create Multiple Dependent Drop Down Lists in Excel (Demonstration with Example up to 3 Levels)

How to Create 0:11:44

How to Create a Dependent Drop Down Lists in Excel (with OFFSET, CHOOSE, INDEX & INDIRECT)

Data Validation Drop 0:01:00

Data Validation Drop Down List - Excel Tips - #youtubeshorts

How to create 0:04:10

How to create a multiple dependent drop-down list in Excel?

Dependent drop down 0:03:55

Dependent drop down trick using Xlookup in excel

Dependent Dropdown And 0:28:19

Dependent Dropdown And Data Validation | Best Advanced Excel Tutorial for Beginners | Henry Harvin

Create dropdown list 0:01:00

Create dropdown list by using Table in Excel

Комментарии
Автор

Very good. However one problem I've always had with dependent drop-down lists is that you can't make the second drop-down box refresh (or clear) when something from the first list is selected. In your example you select Toyota Corolla, then when Ford is selected, Corolla is still shown, even though the drop-down list has been refreshed correctly. If there is some clever hack to achieve this {without resorting to VBA) then I'd love to know it!

ianwilliams