How to Create a Dynamic Drop-Down List in Excel – Excel Tips and Tricks

Here are the steps.
A) Create a list data table
1) Select the data cells from the list.
2) CtrlT
3) Check /"My table has headers/"
4) Okay

B) Create a data validation list
1) Select a cell.
2) Data – Data Validation
3) Allow listing
4) Source set to C2#

C) Extension of the data validation list
1) Select the last item in the data list
2) Tabs
3) Add a list item. for example /"Glue/"
4) Enter

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.