Drop Down List in Excel | Validation Function in excel| Create List in Excel| Excel in Hindi
Drop Down List in Excel | Validation Function in excel| Create List in Excel| Excel in Hindi
In this video, you will learn about the Droplist in excel using the Data Validation formula.
To create a drop-down list in excel we first create the list in a separate sheet and then change the name is the cell for list heading. Once you create the list heading you can go to the function tab and put this formula =listname. Another option is that you can simply go to the list section and enter the names separating by comma and press enter once finish with list.
Please Subscribe & Like my Channel. Also, Please watch other Videos mention below :
Please subscribe the channel with below link:
/ @officegyan1346
Other Useful Videos :
Learn Macros :
• How to use Macro in Excel in Hindi | Macro...
Pivot Tables:
• How to use Pivot Table in Excel in Hindi |...
Conditional Formatting:
• How To Use Conditional Formatting In MS Ex...
#exceltips #officegyan #exceltutorial