Teach to each video on how to create and remove drop down list in excel in hindi. This excel tutorial teach you how to create drop down list in excel in hindi with syntax and examples.
After this video you learn-:
1. How to create drop down list in excel in hindi
2. How to remove drop down list in excel in hindi
3. How to create and remove drop down list in excel 2016,2013,2010
Basically, use of excel drop down list multiple selection is for data accuracy and fast typing.
Steps to Create drop down list is :-
1) Select the cell range where you want to add drop down list and Go to Data Tab
2) Click on Data Validation, choose again data validation
3) Change in criteria from “Any Value” to “List”.
4) Then Select or type data list in “Source” text box.
Steps to Remove drop down list is :-
1) Select the cell range from where you want to remove drop down list and Go to Data Tab
2) Click on Data Validation, choose again data validation
3) Change in criteria from “List” to “Any Value”.
Shortcut to open Drop Don list pop up = ALT + A + V + V
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On youtube, only just few videos are available how to create and remove drop down list in excel. Thanks for watching.
It is humble request to you.
Please subscribe my youtube channel by click on this link
/ teachtoeach
Some popular videos-:
1) Vlookup with Indirect Function in Excel Hindi - • Vlookup with Indirect ...
2) Fuzzy Lookup in Excel Hindi - • Fuzzy Lookup in Excel ...
3) Text To Column in Excel in Hindi - • 🔥 Text To Column in Ex...
4) Vlookup with Match Function in Excel Hindi - • Vlookup with Match Fun...
5) Randbetween Formula in Excel in Hindi - • Randbetween Formula in...
6) Sort Left to Right in Excel Hindi - • Sort Left to Right in ...
7) Cricket Live Score in Excel Sheet - • Cricket Live Score in ...
8) Double Vlookup in Excel Hindi Part-2 - • Double Vlookup in Exce...
9) Sumifs formula in excel hindi - • SUMIFS Formula in Exce...
10) Array Formula in Excel Hindi - • Array Formula in Excel...
11) Excel vlookup formula error #NA #REF #VALUE in hindi - • Excel Vlookup Formula ...
12) 3 Tips to make easy Vlookup Formula in Hindi - • 3 Tips to make easy Vl...
13) Concatenate Formula in Excel Hindi - • Concatenate Formula in...
14) How to calculate Shrinkage and Attrition rate Formula in Excel Hindi - • How to calculate Shrin...
15) Double VLOOKUP in Excel Hindi - • Double Vlookup in Exce...
16) Split first middle and last name by using formula in excel hindi - • Split first middle and...
17) Create Dependent Drop Down List in Excel Hindi - • Create Dependent Drop ...
18) How to make a picture lookup in excel - • How to create a pictur...
19) Relative Absolute and Mixed Cell Referencing in Excel - • Relative Absolute and ...
20) Excel Logical Functions IF AND OR NESTED IF in Hindi - • Excel Logical Function...
21) Reverse Lookup Formula VLOOKUP with Choose Function in Excel - • Reverse Lookup Formula...
22) How to consolidate multiple worksheets into Pivot Table - • How to consolidate mul...
Негізгі бет Create and Remove Drop Down List in Excel in Hindi
Пікірлер: 32