How do I create a dynamic drop down list in Excel - Excel Tips and Tricks #shorts

Learn how to create a dynamic drop down list in Excel.

Here are the steps.
A) Create List Data Table
1) Select the list data cells.
2) Ctrl + T
3) Check on "My table has headers"
4) OK

B) Create Data Validation List
1) Select a cell.
2) Data -- Data Validation
3) Allow set to List
4) Source set to =$C$2#

C) Expanding Data Validation List
1) Select last item in the Data List
2) Tabs
3) Add list item. eg "Glue"
4) Enter

#excel #tips #shorts #fyp

Видео How do I create a dynamic drop down list in Excel - Excel Tips and Tricks #shorts канала Jasmine Jones