3 Method to Create a Drop Down List in Excel HINDI│एक्सल में ड्राप डाउन लिस्ट बनाने के 3 तरीके
HTML-код
- Опубликовано: 11 сен 2024
- 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.
LIKE | COMMENT | SHARE | SUBSCRIBE
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u
VERY EASILY EXPLAINED SIR
Tnq so much sir❤❤❤
All tips bahut bdiya hai
Bahut bahut tq
THNKX
welcome bro
Sir Bhut hi useful video...mujhe need thi iski..Thank you sir
Thank you
It's good for new learner, thanks for sharing valuable
Your Welcome
Very help full
Wow.... explained very well
2nd method was very easy
Thinks.. For the video
Your welcome
Explained very easily. Liked it.
Thanks
Bahut hi helpful bhai 👌👌
Thank you bro really really appreciate...
Thanks
Very nice & usefull..
Very Helpful Sir
Thanks bro ☺️
Thanku so much
first class.
bohat achi video ha very nice 3 method is super and ur r great sir
Very helpful main kabse internet par searching kar rahi thi 👍👍
Thanks your method of telling is best
It's really helpful ❤️, thank you
your welcome
Very useful
EXTREMELY INFORMATIVE.THANK YOU.
Excellent
बहुत अच्छी तरह से समजाते हैं ।👍
Very nice video
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.
Thankyou sir!!
Very knowledgeable .
Good Jobs Thanks
Nyc knowledge vedios.
Thank you for knowledge sharing!!!
very helpfull. i search time to time
Thanks
Thank you....My problem is solve.
Very nice thanks Sir.
Your welcome
Verry brother 👍👍👍
Excellent teaching
Very time excel tips
Very simple and informative
Very nice
Thanks sir bahut achha gyan mila
Thanks a lot
Thanks
Welcome
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.
Sir mujhe yah video bhut hi pasand aaya isi automatically date wala format bata de to bhut accha rahega
ya mera bhi yehi hai.
excellent
Thanks sir
Thanku sir
Thanks
Very helpful, thank you.
Nice and very uarfull video sir
thanks.
good
Great video, reduced my work by half
thanks
Excellent sir
TQ for the information 👍👍👍
Very helpful thanx
Amazing knowledge
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.
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 :)
@Colt Paxton Definitely, I've been watching on Instaflixxer for since december myself :D
Thank you
Very nice sir
thanks
Vai apke video maja agaya. sabais
Fine👍
Second wala option boht hi Aachha tha
okay
marvelous
Bahut sahi sir
Thanks brother
thanks
Bahot badhiya. में आपका video देखते ही आपर फिदा हो गया. आपका समझाने का तरीका बहोत अच्छा है, मेंने आपका चैनल subscribe करलीया. मुजको यही Farmule mobile में use करके दिखावो.
Thanks.
Excellent. All are very useful.
Glad you think so!
Very nicely explained each step. Thanks
So nice of you
nice video sir
Thank you very much sir
Very interesting video.
Very Clear
Good
thanks
👍👍 thanks for this informative video.
Thank you
Wow sir
Excellent.
Thanks for uploading this video.
thanks.
MANY MANY TNX BRO
last method mujhe achha laga
thanks, its good for all sheet.
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.
Nice brother
thanks.
Thanks very helpful formula..
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. ?
Really informative video
Thank
Thanks you sir mujhe apse class chiye
2nd third both is best❤
thanks for the comment
Perfect
Nyc
Nice explanation please tell how can we create drop down list in anroid mobile excel 365 sir ji
Option 2 is best
Very nice video sir
Thank you
Govind Sir,
Fantastic video! मगर तीसरे cities वाले method में हम cities वाले data को control+T की help से table बना लें तो automatic effect data validation में आ जाएगा | क्या ऐसे हो सकता है? ; )
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.
3rd wala acha hai.
Cricket score ko excell me forrmula ke sath banae ke liye koi video upload karo. Plzz
thanks, but cricket ke score ko formule se kaise bna sakte hai.
Tino hi achha hai, sir
Kya apna khud ka formula create kr skte hai....
2nd I found best
Like it
Thnk u bro
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
बहुत अच्छा सर
क्या हम जिस वर्कबुक पर कार्य कर रहे है वहाँ पर दूसरे वर्कबुक से ड्राप डाउन लिस्ट बना सकते है? यदि हा तो बताइए।
नहीं दूसरी वर्कबुक से नहीं होगा. अगर होगा ही तो जब तक शीट ओपन होगी तभी एक। शीट क्लोज करने के बाद डेटा का सोर्स ख़त्म हो जायेगा और ड्राप डाउन लिस्ट में एरर आ जायेगा.
👍👍👍👍👍👍
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?
Possible to hai but kuch formula extra apply karn padega ho jayega
@@ComTutor wahi to puchna he Sirji... Pls bataiye....
Cell color bhi change kr sakte?
Uske liye condition for formatting karna hoga
🙌👏🏼👏🏼👏🏼👏🏼👏🏼
ड्रॉप डाउन लिस्ट कैरियत तो कर लेते लेकिन उस एक्सल शीट को दूसरे पीसी में ई-मेल द्वारा भेजते हैं तो ड्रॉप डाउन लिस्ट उस सीट में काम नहीं करती है यानी स्वत ही ड्रॉपडाउन ऑप्शन हट जाता