Bahot badhiya. में आपका video देखते ही आपर फिदा हो गया. आपका समझाने का तरीका बहोत अच्छा है, मेंने आपका चैनल subscribe करलीया. मुजको यही Farmule mobile में use करके दिखावो. Thanks.
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.
ये ड्राप डाउन बनाने के तीन method नहीं है.... ये लिस्ट में source देने के 3 प्रकार थे....बस आपकी जानकारी के लिए बता दूं कि सामान्यतः एक्सेल में list बनाने का method सिर्फ एक ही है... और वो है.... data रिबन में data validation then list....
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.
Maine workers ki per day ka working details banaya hoon aur unki designation technician name agar koi extra workers ya technician kaise add karu data validation se
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 :)
drop down lagane se pehle saaare cell ko select karo jha drop down lagana hai. uske baad drop down apply kar. aapne first line select karke kiya isliye first line mei hi work kar rha hai
Last option usi ke liye hai jisme hamne data ko alag sheet mei rakha hai phir apko uss data ka naam rakhna hoga phir usko drop dwon mei naam ko enter karne par wo range ban jayegi.
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.
Bhai ek udf file chahiye. Excel mai welcome screen k addin bnanae k liye ki jb excel open kre to ek welcome screen open ho or phir kuch time period k baad wo close ho or excel open ho jaye mene welcome screen bna li h pr udf coding kaam ni krri is pr ek video bna do ya udf file dedo
I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it with data validation WITHOUT USING VBA?
ड्रॉप डाउन लिस्ट कैरियत तो कर लेते लेकिन उस एक्सल शीट को दूसरे पीसी में ई-मेल द्वारा भेजते हैं तो ड्रॉप डाउन लिस्ट उस सीट में काम नहीं करती है यानी स्वत ही ड्रॉपडाउन ऑप्शन हट जाता
नहीं दूसरी वर्कबुक से नहीं होगा. अगर होगा ही तो जब तक शीट ओपन होगी तभी एक। शीट क्लोज करने के बाद डेटा का सोर्स ख़त्म हो जायेगा और ड्राप डाउन लिस्ट में एरर आ जायेगा.
Sir mere help kariye please! Muze drop down list ka ulta bataaiye I meant mere pass pahle se hi 1 cell hai jisme drop down pahle se hi hai muze uske andar ka data drop down list se free karke 1 columns me lana hai to kaise kare Please help me!!! Aapka bahut badi kripa hogi mere madat karne ke liye
Hi. Drop down wale cell to click karo. Go to data tab- select data validation. Wahan SOURCE me aapko cell address miljaega, check it and you'll find your source list.
Ek help kr do.. Esa ek vedio banao jisme excel ke sirf useful option or formulas ho... Excel is broad application jitna jada profoundly jao utna confusion so pls mandatory formulas, option hi batao
All tips bahut bdiya hai
Bahut bahut tq
Very helpful main kabse internet par searching kar rahi thi 👍👍
Tnq so much sir❤❤❤
Kya apna khud ka formula create kr skte hai....
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 nice tips💡
Bahut hi helpful bhai 👌👌
Bahot badhiya. में आपका video देखते ही आपर फिदा हो गया. आपका समझाने का तरीका बहोत अच्छा है, मेंने आपका चैनल subscribe करलीया. मुजको यही Farmule mobile में use करके दिखावो.
Thanks.
Wow.... explained very well
2nd method was very easy
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.
Cell color bhi change kr sakte?
Uske liye condition for formatting karna hoga
It's really helpful ❤️, thank you
your welcome
Nice explanation please tell how can we create drop down list in anroid mobile excel 365 sir ji
Sir ji ke side me mark aata ha ,is ke bina drop down list bana sakta ha kaya
Explained very easily. Liked it.
Thanks
EXTREMELY INFORMATIVE.THANK YOU.
Sir mujhe yah video bhut hi pasand aaya isi automatically date wala format bata de to bhut accha rahega
ya mera bhi yehi hai.
Great video, reduced my work by half
thanks
Very Helpful Sir
Thanks bro ☺️
Thank you bro really really appreciate...
Thanks
Thanks your method of telling is best
Very nice & usefull..
Thankyou sir!!
Very knowledgeable .
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....
Excellent teaching
bohat achi video ha very nice 3 method is super and ur r great sir
Very simple and informative
very helpfull. i search time to time
Thanks
ये ड्राप डाउन बनाने के तीन method नहीं है.... ये लिस्ट में source देने के 3 प्रकार थे....बस
आपकी जानकारी के लिए बता दूं कि सामान्यतः एक्सेल में list बनाने का method सिर्फ एक ही है... और वो है.... data रिबन में data validation then list....
Can we aarange A-Z city name in Drop Down ????
Verry brother 👍👍👍
VERY EASILY EXPLAINED SIR
Excellent sir
how to make drop down list if any condition let say minus from b3 to b9
help required
Sir mereko GST invoice me party ka name list view mese select kru to puri details aa jaye.. asa kese kre please batao... video bnake
Nice and very uarfull video sir
thanks.
Ye formula android phone me kar sakte he kya?
Mujse nahi huva
Excellent. All are very useful.
Glad you think so!
Very nicely explained each step. Thanks
So nice of you
Thanks sir bahut achha gyan mila
Sir 3rd cities vala thoda samja nahi aapne kya dala usme = ya kuch aur
Second wala option boht hi Aachha tha
okay
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.
TQ for the information 👍👍👍
👍👍 thanks for this informative video.
Thank you
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.
Thank you....My problem is solve.
Dusre sheet ke data ko kase Drop dawon list bnaye
Dusre sheet se working sheet mei copy paste karke same sheet mei banao.
@@ComTutor bnaya but nhi bn rha
Sir aapne name manager se jo jodhpur add kiya he list me mujse to ho nhi rha
Thanks you sir mujhe apse class chiye
Thanks nice info
Maine workers ki per day ka working details banaya hoon aur unki designation technician name agar koi extra workers ya technician kaise add karu data validation se
सर प्लीज बताएं कि excel में कैसे drop down लिस्ट को mouse के roller से ऊपर नीचे करें। plz help me.
Very helpful, thank you.
Helpful , Thankyou
your welcome
Nyc knowledge vedios.
Very nice sir
thanks
very nice but how to use this in form
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
Sir in first line of drop down list drop down is working but not in 2nd line
drop down lagane se pehle saaare cell ko select karo jha drop down lagana hai. uske baad drop down apply kar.
aapne first line select karke kiya isliye first line mei hi work kar rha hai
Amazing knowledge
THNKX
welcome bro
Agar sara data ko alag sheet main main data ko alag sheet main rakhna ho tou
Last option usi ke liye hai jisme hamne data ko alag sheet mei rakha hai phir apko uss data ka naam rakhna hoga phir usko drop dwon mei naam ko enter karne par wo range ban jayegi.
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.
Sir drop out box me search option milega
Bhai ek udf file chahiye. Excel mai welcome screen k addin bnanae k liye ki jb excel open kre to ek welcome screen open ho or phir kuch time period k baad wo close ho or excel open ho jaye mene welcome screen bna li h pr udf coding kaam ni krri is pr ek video bna do ya udf file dedo
okay mil jayegi I'll share soon.
Thanks bhai
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. ?
I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it with data validation WITHOUT USING VBA?
3rd option is getting error in source data. When i try to change name in that left upper box and press enterPlease try to explain again.
Mujhe ek portal pe data upload krna hair using macros...kse krenge
uske liye aap macro record kar sakte hai then usko run kra sakte hai.
Excellent.
Thanks for uploading this video.
thanks.
bhai yadi ek single cell ko edit karke saari excel sheet m wahi cell k drop down list edit ho jayegi kya
Agar list me ek hi nam 4 bar ho to drop down me bhi 4 bar so karta hai kya use ek bar sow nahi kiya ja sakta hai
Excellent
ड्रॉप डाउन लिस्ट कैरियत तो कर लेते लेकिन उस एक्सल शीट को दूसरे पीसी में ई-मेल द्वारा भेजते हैं तो ड्रॉप डाउन लिस्ट उस सीट में काम नहीं करती है यानी स्वत ही ड्रॉपडाउन ऑप्शन हट जाता
Very nice video
Good Jobs Thanks
Very useful
Very helpful thanx
जब कॉपी पेस्ट करते है ड्राप डाउन हट जाता है ऐसा किया करे जो ड्राप डाउन नही हटे ऐसी कोई जानकारी दे
Thinks.. For the video
Your welcome
please sir tell me how to increase font size in drop down list to make it visible
Vai apke video maja agaya. sabais
Sir plz make video on shortcut keys like name manager etc advance shortcut keys
okay
बहुत अच्छा सर
क्या हम जिस वर्कबुक पर कार्य कर रहे है वहाँ पर दूसरे वर्कबुक से ड्राप डाउन लिस्ट बना सकते है? यदि हा तो बताइए।
नहीं दूसरी वर्कबुक से नहीं होगा. अगर होगा ही तो जब तक शीट ओपन होगी तभी एक। शीट क्लोज करने के बाद डेटा का सोर्स ख़त्म हो जायेगा और ड्राप डाउन लिस्ट में एरर आ जायेगा.
first class.
Fine👍
सर जी , मेरे पास कृतीदेव फॉन्ट में डाटा है ....क्या ड्राप डाउन लिस्ट में कृतीदेव फॉन्ट दिखाई दे सकता है ....?? कोई तरीका हो तो बताये ...
Thank you very much sir
Very interesting video.
Very Clear
Sir mere help kariye please!
Muze drop down list ka ulta bataaiye
I meant mere pass pahle se hi 1 cell hai jisme drop down pahle se hi hai muze uske andar ka data drop down list se free karke 1 columns me lana hai to kaise kare
Please help me!!!
Aapka bahut badi kripa hogi mere madat karne ke liye
Hi. Drop down wale cell to click karo. Go to data tab- select data validation. Wahan SOURCE me aapko cell address miljaega, check it and you'll find your source list.
Bahut sahi sir
Ek help kr do.. Esa ek vedio banao jisme excel ke sirf useful option or formulas ho... Excel is broad application jitna jada profoundly jao utna confusion so pls mandatory formulas, option hi batao
okay, I am going to make a video on interview question, so I'll cover all important question.
Thanks brother
thanks
Thanks very helpful formula..
Please tell how to create date drop down list
make a list of date and then in the source data pick that date list it will create.
last method mujhe achha laga
thanks, its good for all sheet.
Very help full
Sir source dlt kar Dene se drop down nahi ho raha hai
Yedi ham capital chahten hai to kya karen?