3 Method to Create a Drop Down List in Excel HINDI│एक्सल में ड्राप डाउन लिस्ट बनाने के 3 तरीके

How to add a drop-down list to an Excel cell or Create a drop-down list and Create a Drop Down List in Excel dependent drop down list in excel
A drop-down list is an excellent way to give the user an option to select from a pre-defined list.
It can be used while getting a user to fill in a form, or while creating interactive Excel dashboards.
This Tutorial Covers:
How to Create a Drop Down List in Excel
#1 Using Data from Cells
#2 By Entering Data Manually
#3 Using Excel Formulas
==============To Download This video Drop-down list Excel sheet click below link==================
drive.google.c...
=========================================================================================
Drop-down lists are quite common on websites/apps and are very intuitive for the user.
In this tutorial, you’ll learn how to create a drop-down list in Excel (it takes only a few seconds to do this) along with all the awesome stuff you can do with it.
How to Create a Drop Down List in Excel
In web forms, surveys, and polls, it can be very useful to limit the choices for a selection with a simple drop-down list. This is also possible in an Excel spreadsheet, but the process isn't very well known or very intuitive.
In Access, you can limit user entries by forcing users to choose a value from a list control. Office applications use the same functionality in built-in drop-down lists. For instance, the Highlight and Font Color control on most Formatting toolbars use this flexible tool. Simply click the small triangle to the right of the icon to display a list of choices.
You can create the same type of control for your users in an Excel sheet, but the process isn't intuitive. The option is in the Data Validation feature. Fortunately, once you know the feature exists, it's easy to implement. You need only two things: a list and a data entry cell. The following sheet shows a simple drop-down list in an Excel sheet.
Users click the drop-down arrow to display a list of items from A1:A4. If a user tries to enter something that isn't in the list, Excel rejects the entry. To add this drop-down list to a sheet, do the following:
Create the list in cells A1:A4. Similarly, you can enter the items in a single row, such as A1:D1.
Select cell E3. (You can position the drop-down list in most any cell or even multiple cells.)
Choose Validation from the Data menu.
Choose List from the Allow option's drop-down list. (See, they're everywhere.)
Click the Source control and drag to highlight the cells A1:A4. Alternately, simply enter the reference (=$A$1:$A$4).
Make sure the In-Cell Dropdown option is checked. If you uncheck this option, Excel still forces users to enter only list values (A1:A4), but it won't present a drop-down list.
Click OK.
You can add the drop-down list to multiple cells. Select the range of data input cells (step 2) instead of a single cell. It even works for noncontiguous cells. Hold down the Shift key while you click the appropriate cells.
A few quick notes:
You can only see the drop-down if you click on the cell.
Your users can now only choose one of the options in the drop-down. If they try to enter their own data, then they'll receive an error message.
You can copy-and-paste this drop-down cell to any other cells in your spreadsheet, and you can create as many different drop-downs like this as you'd like.
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u

[@AccountsTeam-f5d]

VERY EASILY EXPLAINED SIR

[@Santosh96084]

Tnq so much sir❤❤❤

[@shivasagar3774]

All tips bahut bdiya hai
Bahut bahut tq

[@MinhajuddinAhmed]

THNKX

[@ComTutor]

welcome bro

[@pankajsaini50]

Sir Bhut hi useful video...mujhe need thi iski..Thank you sir

[@ComTutor]

Thank you

[@udayprasad9764]

It's good for new learner, thanks for sharing valuable

[@ComTutor]

Your Welcome

[@rishipatel7314]

Very help full

[@maksudalam2697]

Wow.... explained very well
2nd method was very easy

[@asitbauri3572]

Thinks.. For the video

[@ComTutor]

Your welcome

[@navinmehta8721]

Explained very easily. Liked it.

[@ComTutor]

Thanks

[@JeetuStark]

Bahut hi helpful bhai 👌👌

[@jack75374]

Thank you bro really really appreciate...

[@ComTutor]

Thanks

[@sheetalpatil2571]

Very nice & usefull..

[@DhandhalaMukesh]

Very Helpful Sir

[@ComTutor]

Thanks bro ☺️

[@poojasingh-su8jh]

Thanku so much

[@krishnabhattarai9106]

first class.

[@ibraheemmshezad400]

bohat achi video ha very nice 3 method is super and ur r great sir

[@lachhmijas8790]

Very helpful main kabse internet par searching kar rahi thi 👍👍

[@naranjansingh1623]

Thanks your method of telling is best

[@souravkarmakar964]

It's really helpful ❤️, thank you

[@ComTutor]

your welcome

[@balramsharma1]

Very useful

[@sdutta20]

EXTREMELY INFORMATIVE.THANK YOU.

[@Tara-zp3gb]

Excellent

[@socialscienceeducation785]

बहुत अच्छी तरह से समजाते हैं ।👍

[@krishnapalginare2964]

Very nice video

[@AdityaSharma-rg1zn]

M watching ur video fr first tym, but yes I blv this video has described drop down in best mnnr. Plus it's much small video too.. guys keep playing video at 1.25 x to save ur time.

[@sanjaysirclasses9116]

Thankyou sir!!
Very knowledgeable .

[@falehsaleh124]

Good Jobs Thanks

[@subhashpandey4355]

Nyc knowledge vedios.

[@kamleshrane5138]

Thank you for knowledge sharing!!!

[@rajdigitalmedia3796]

very helpfull. i search time to time

[@ComTutor]

Thanks

[@sanjoydutta5118]

Thank you....My problem is solve.

[@dipakthite2943]

Very nice thanks Sir.

[@ComTutor]

Your welcome

[@rafik039]

Verry brother 👍👍👍

[@syedashraf6024]

Excellent teaching

[@abhiyadav994]

Very time excel tips

[@deepalibhosale4776]

Very simple and informative

[@anitachandola299]

Very nice

[@Monster_Frankenstein]

Thanks sir bahut achha gyan mila

[@devendrasinghchauhan8254]

Thanks a lot

[@dipeshkorram6702]

Thanks

[@ComTutor]

Welcome

[@kums_creations]

Nice
Thank you sir
Plz sir make a video on
Excel
When data (information with code/item no. ) on a one sheet and create a filled form in another sheet by a item no. With its information in desired format.

[@yogendramishra3128]

Sir mujhe yah video bhut hi pasand aaya isi automatically date wala format bata de to bhut accha rahega

[@ComTutor]

ya mera bhi yehi hai.

[@mdazamazam7988]

excellent

[@DSI354]

Thanks sir

[@SurenderKumar-ls7co]

Thanku sir

[@ComTutor]

Thanks

[@RavindraKumar-wv7gf]

Very helpful, thank you.

[@prabhakarpawar573]

Nice and very uarfull video sir

[@ComTutor]

thanks.

[@worldexpress9186]

good

[@harshita40]

Great video, reduced my work by half

[@ComTutor]

thanks

[@AbcDef-nm4ql]

Excellent sir

[@sandipkisan9587]

TQ for the information 👍👍👍

[@surbhigupta3706]

Very helpful thanx

[@ankitasagar2304]

Amazing knowledge

[@knoweconomics1]

Very interesting and educative. Keep posting such types of vedios. We are waiting for your next post regarding how to prepare a cash book in excel for a small educational institution.

[@coltpaxton7798]

You prolly dont give a shit but if you are stoned like me atm you can watch pretty much all of the new movies and series on Instaflixxer. Have been binge watching with my brother recently :)

[@karsynzakai9000]

@Colt Paxton Definitely, I've been watching on Instaflixxer for since december myself :D

[@inamulhaque3813]

Thank you

[@prajaktavangad3588]

Very nice sir

[@ComTutor]

thanks

[@jameskandpan6099]

Vai apke video maja agaya. sabais

[@balchandrasisodiya5739]

Fine👍

[@manojwashinde6615]

Second wala option boht hi Aachha tha

[@ComTutor]

okay

[@gpsingh5059]

marvelous

[@govindc3761]

Bahut sahi sir

[@yogendrabohra8479]

Thanks brother

[@ComTutor]

thanks

[@maulanazafershaink7266]

Bahot badhiya. में आपका video देखते ही आपर फिदा हो गया. आपका समझाने का तरीका बहोत अच्छा है, मेंने आपका चैनल subscribe करलीया. मुजको यही Farmule mobile में use करके दिखावो.
Thanks.

[@Ammu.gaming529]

Excellent. All are very useful.

[@ComTutor]

Glad you think so!

[@beautifulwonderfulworldbww5585]

Very nicely explained each step. Thanks

[@ComTutor]

So nice of you

[@beenglishman3062]

nice video sir

[@JagtarSingh-bw8dm]

Thank you very much sir
Very interesting video.
Very Clear

[@zaingujjar2213]

Good

[@ComTutor]

thanks

[@poojadas378]

👍👍 thanks for this informative video.

[@ComTutor]

Thank you

[@soniamaurya5228]

Wow sir

[@MdIlyasShaikh]

Excellent.
Thanks for uploading this video.

[@ComTutor]

thanks.

[@mahaboobhossain5076]

MANY MANY TNX BRO

[@maonojkumarkhilarmuna3748]

last method mujhe achha laga

[@ComTutor]

thanks, its good for all sheet.

[@ITTEHADchannel]

Ek aisa video banayein!
Jo drop down list se koyi material lene ke baad uski quantity add karte hi stock mein se kam ho jaya kare
Doosri jagah quantity plus add karne par apne aap stock badh jaaye.

[@damodarbangalore7003]

Nice brother

[@ComTutor]

thanks.

[@milinpsheth]

Thanks very helpful formula..

[@amitka1234]

Very nice, I was searching all this since long time back. Does the newly inserted row in example 3 automatically show the related list box. ?

[@azizniazi2454]

Really informative video

[@ComTutor]

Thank

[@IMRANSHAIKH-vr2yp]

Thanks you sir mujhe apse class chiye

[@Sudarshanjha1]

2nd third both is best❤

[@ComTutor]

thanks for the comment

[@harshalisharma3709]

Perfect

[@PalakSuryavanshi129]

Nyc

[@dalpatisharma2520]

Nice explanation please tell how can we create drop down list in anroid mobile excel 365 sir ji

[@abanissssssss9621]

Option 2 is best

[@AshaSiyan]

Very nice video sir

[@ComTutor]

Thank you

[@puneetvij8433]

Govind Sir,
Fantastic video! मगर तीसरे cities वाले method में हम cities वाले data को control+T की help से table बना लें तो automatic effect data validation में आ जाएगा | क्या ऐसे हो सकता है? ; )

[@ComTutor]

bilkul ho sakta hai isse aap data ko Table mei convert kar payegne. aur isse heading bhi drop down mei nahi aaygi.
nice option. good keep it up.

[@siddiquifaizan8369]

3rd wala acha hai.
Cricket score ko excell me forrmula ke sath banae ke liye koi video upload karo. Plzz

[@ComTutor]

thanks, but cricket ke score ko formule se kaise bna sakte hai.

[@nehasingh098]

Tino hi achha hai, sir

[@ManojKumar-me8qk]

Kya apna khud ka formula create kr skte hai....

[@subho516]

2nd I found best

[@rajeshkumarbhagat9739]

Like it

[@ishfaqahmad9708]

Thnk u bro

[@mahmoodmunawar1132]

Hi I m a follower of your xl videos and I really appreciate your efforts to spread knowledge. I need you tutorial on dates range between start & finish given dates like as we work in schedule at last minimum value as start date with actual dates as 1-Feb-19 A and maximum value as finish date 25-Feb-19 A. if u can help me with advance formula to fix dates range between start and finish date it will help me a lot. Thanks in advance Munawar

[@AjayT81]

बहुत अच्छा सर
क्या हम जिस वर्कबुक पर कार्य कर रहे है वहाँ पर दूसरे वर्कबुक से ड्राप डाउन लिस्ट बना सकते है? यदि हा तो बताइए।

[@ComTutor]

नहीं दूसरी वर्कबुक से नहीं होगा. अगर होगा ही तो जब तक शीट ओपन होगी तभी एक। शीट क्लोज करने के बाद डेटा का सोर्स ख़त्म हो जायेगा और ड्राप डाउन लिस्ट में एरर आ जायेगा.

[@anupbhattacharyya2829]

👍👍👍👍👍👍

[@kushsharma2480]

Dropdown select karne alawa start me kuch alphabet type kiye to list me sirf usi alphabet ka aana chaiye na ki puri list... Ye possible he kya?

[@ComTutor]

Possible to hai but kuch formula extra apply karn padega ho jayega

[@kushsharma2480]

@@ComTutor wahi to puchna he Sirji... Pls bataiye....

[@gagu231]

Cell color bhi change kr sakte?

[@ComTutor]

Uske liye condition for formatting karna hoga

[@RajKumar-kv4ld]

🙌👏🏼👏🏼👏🏼👏🏼👏🏼

[@mansingh994]

ड्रॉप डाउन लिस्ट कैरियत तो कर लेते लेकिन उस एक्सल शीट को दूसरे पीसी में ई-मेल द्वारा भेजते हैं तो ड्रॉप डाउन लिस्ट उस सीट में काम नहीं करती है यानी स्वत ही ड्रॉपडाउन ऑप्शन हट जाता