How To Create Dependent Drop Down List In Excel || Best Video || Hindi || HD

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 510

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому +12

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

    • @rohitchouhan6087
      @rohitchouhan6087 4 роки тому

      It's really helpful thanks a lot more making informative videos like this though I have a small questions,how to apply this dependent drop down in complete row, as when m trying to do so by ctrl+D it's not happening. Please suggest

    • @AparBlog
      @AparBlog 4 роки тому +1

      Very👌👌👌👏👏👏👏👏nice

    • @AparBlog
      @AparBlog 4 роки тому +2

      Mujhe excel ki koi knowledge nhi thi apke channel se knowledge se aaj me achha job kar raha hu ??????

    • @AparBlog
      @AparBlog 4 роки тому

      Very good

    • @shubhamgupta-qm3xy
      @shubhamgupta-qm3xy 4 роки тому

      Hello depak ji can u plss tell my how to create a dropdown list which allows duplicate entries

  • @nandpal5783
    @nandpal5783 6 місяців тому +3

    Aapka video hamesha kafi accha rahta hai hamesha sir,

  • @Mumtaz022
    @Mumtaz022 4 місяці тому +1

    bhai mien ne aj tak youtube par koi esa youtuber nhi dekha jo etni logic aur acha method se samjhata hon jitna powerfull ap samjhty ho

  • @vickyaswal4961
    @vickyaswal4961 3 роки тому +5

    आपका समझाने का तरीका बहुत शानदार है,, बहुत बहुत धन्यवाद आपका

  • @lalat007
    @lalat007 9 місяців тому +1

    Very nice Sir

  • @KDS-v6r
    @KDS-v6r 4 роки тому +1

    VERY VERY MUCH THANK YOU

  • @AnilKumar-qf7gd
    @AnilKumar-qf7gd 3 роки тому +1

    Bahut badhiya tarike se samjhayaa hai. Facts bhi clear kiye hain. Kuch log just kaam chalau hi karte hain. You are good brother. Thanks and Regards

  • @akashlande257
    @akashlande257 4 роки тому

    Sir ji apko salute kitne din se yehi dhund raha tha main... mil gaya.... lvu lvu lvu😘

  • @santoshkumarkar39
    @santoshkumarkar39 2 роки тому +1

    Dependent drop drown list in Excel... Fantastic...

  • @simplified6840
    @simplified6840 3 роки тому +1

    Superb video. Easiest & best way to create a drop-down

  • @kanchanbhagat5602
    @kanchanbhagat5602 2 роки тому

    Video ekdum mast tha.
    Thank you sir. Isse pahle mujhe pata hi nahi tha ki aisi list bhi hoti hai 👌👌👌

  • @nalingu
    @nalingu 5 років тому +4

    Thank you so much .. I watched so many videos to understand but failed. This time understood very well...

  • @sureshnagwan7805
    @sureshnagwan7805 3 роки тому +1

    बहुत ही अच्छी तरह से समझ में आ गया 🙏

  • @shoheltamboli855
    @shoheltamboli855 3 роки тому +2

    Very helpful and easy to understand thanks Deepak

  • @likkydevendher2417
    @likkydevendher2417 6 років тому +1

    GOOD WORKING DEEPAK BHAI MAINE APPKA VIDEOS DEK KE BHAHUTH KUCH LEARN KIYA THANK YOU SO MUCH SIRJI

  • @rakeshmeshram0993
    @rakeshmeshram0993 6 років тому +1

    Aapki language bhut achi hai batane ki ,

  • @kiran6602
    @kiran6602 6 років тому +1

    sir plz advanced excel me financial functions pe vdo banaye ....apke vdo bahut helpful hote hain..thanx sir

  • @popatraut685
    @popatraut685 2 роки тому

    लय भारी सर समजले व प्रत्यक्षात केले व मला जमले कारण तुमचे बोलणे खुपच छान शब्दन शब्द कळतो लगेच धन्यवाद सरजी!

  • @KDS-v6r
    @KDS-v6r 4 роки тому +1

    VERY VERY MUCH THANK YOU
    SIR ---------

  • @1026neeraj
    @1026neeraj 6 років тому +1

    बहुत अच्छे मज़ा आ गया

  • @adiyogi453
    @adiyogi453 Рік тому +1

    Good explanation!
    Suppose I need to create a sheet with country, state, district etc. Now I select India> UP>Kanpur. But is it possible, if I select Kanpur automatically UP & India would populate?

  • @durgadassaaryawart5625
    @durgadassaaryawart5625 6 років тому

    DEEPAK SIR .. I VERY LIKE YOU AND UR TEACHING SKILL..
    .
    MUJE ITNA MERI COCHING SE SIKHNE KO NHI MILTA JITNA AAPSE MILTA HE .. THANKU SIR

  • @Life_of_pratik
    @Life_of_pratik Рік тому

    Keep up the good work learning daily from u

  • @seemajaiswal9497
    @seemajaiswal9497 6 років тому

    very nice video sir..bahut easily samjhaya thankx......sir ji

  • @N.LAGENT
    @N.LAGENT 4 роки тому

    bht kamal videos hn apki

  • @introspectionnecessary9533
    @introspectionnecessary9533 2 роки тому +1

    Thank u so much keep making videos👌👌👌👌

  • @aakashbhawsar9174
    @aakashbhawsar9174 5 років тому

    Thnks deepak bro... nyc..... aaj mene bahut kuch sikha bro is video se

  • @mdrifat-os8ti
    @mdrifat-os8ti 4 роки тому +1

    Thank you so much bhaiya. It is realy helpful.

  • @shiwanisingh1509
    @shiwanisingh1509 4 роки тому +1

    👍

  • @TheVishwajitj
    @TheVishwajitj 5 років тому +1

    Awesomely explained. You are better than so many professionals of international repute

  • @newsandvlogs9130
    @newsandvlogs9130 3 роки тому

    Bahut Dhanyavad.

  • @nirupammishra7434
    @nirupammishra7434 3 роки тому

    🙏easy process apne bataiye...
    Thanks.
    But ek query hai koi country field me supposed ek city kom ho tahb is processe hoga?

  • @opsgog7082
    @opsgog7082 2 роки тому +1

    Very informative video....loves your explanation procedure....Thanks..

  • @shahabaliabbasi1882
    @shahabaliabbasi1882 6 років тому

    Buhat buhat informative video Sir. Alot of love respect for you from Pakistan

  • @littledev9936
    @littledev9936 6 років тому

    Sir aap very good teaching karne hai.thankus

  • @iskobhidekho2302
    @iskobhidekho2302 Рік тому +1

    Great information...thanx sir

  • @ahmedr.shaikh4006
    @ahmedr.shaikh4006 5 років тому +2

    Ek No.

  • @shubhamkapoor9109
    @shubhamkapoor9109 3 роки тому

    Really very very helpful. Very nice sir

  • @sachinamrutkar228
    @sachinamrutkar228 3 роки тому +1

    Very Nice Sir
    Thank You So Much 🙏🙏🙏

  • @Vikas-oz7bi
    @Vikas-oz7bi 6 років тому +1

    sir bahut hi acchi jankari hain
    sir ek dependent list colour wali banana jisme automatic hi colour change ho jate hain sheet 1 se sheet 2 par
    sir ek iska bhi video banakar upload kijiye

  • @abhishekdsl
    @abhishekdsl 3 роки тому +3

    Thanks for the awesome trick. I have one question. How to remove the space from the drop down list if you don't have equal number of cities under all the countries? If you have only 3 cities under Japan, then there will be 2 blank options in the drop down list. How to fix that?

  • @subhajitdutta8653
    @subhajitdutta8653 4 роки тому

    Excel ka badsha dipak Vai🖤

  • @RaviKumar-jq3dh
    @RaviKumar-jq3dh 2 роки тому

    Thank you so much
    It helped me exactly I was looking for.

  • @nawabnajaf
    @nawabnajaf 4 роки тому

    Thanks for creating such a simplest video

  • @krmotionexcel
    @krmotionexcel 6 років тому

    Best video in excel.....
    I Like a master file in Excel but I m not make it........
    please can you make it master file this sub 👉 like product order list .
    ( Hint :- sheet 1(master sheet) all products details or rate / tax value
    Sheet 2 is order sheet.........
    Sir is the amazing trick.......
    Plz make it

  • @jitendrabomble2218
    @jitendrabomble2218 3 роки тому

    Thanks sir.
    Very very useful lesson.
    👌👌👍👍🌹🌹

  • @bpsingh5994
    @bpsingh5994 5 місяців тому +1

    Excellent

  • @AmitKumar-jv4sw
    @AmitKumar-jv4sw 6 років тому +2

    Superb sir...easy to understand

  • @santoshkumarkar39
    @santoshkumarkar39 2 роки тому +1

    Sir thank you very much

  • @AshaSiyan
    @AshaSiyan 5 років тому +1

    Sir your video is too good.

  • @seemajaiswal9497
    @seemajaiswal9497 6 років тому +1

    bahut accha sir u r rocking

  • @anilkumarsingh4560
    @anilkumarsingh4560 6 років тому

    SUPERHIT VIDEO

  • @AshaSiyan
    @AshaSiyan 5 років тому +1

    Ab think ho Gaya .thank u very very much sir.

  • @prasheelkamat1755
    @prasheelkamat1755 6 років тому

    Good teaching

  • @juweriyanahadi9184
    @juweriyanahadi9184 3 роки тому

    New subscriber! very informative n detailed explanation.

  • @syedabbas201
    @syedabbas201 3 роки тому +1

    Thanks dear me ye hi video fine kr rha rha tha... Subscribe Done Like done Bill icon Done

  • @narsinghpujari3497
    @narsinghpujari3497 6 років тому +1

    bahut hi upyogi video hai
    thanks sir ji

  • @arslanghazi2386
    @arslanghazi2386 2 роки тому

    Love you sir from Pakistan 🇵🇰🇵🇰🇵🇰

  • @balajikendre1985
    @balajikendre1985 6 років тому +1

    Very useful video.Thanks.

  • @sayalisawant7787
    @sayalisawant7787 5 років тому +1

    Good one

  • @gurunandan9977
    @gurunandan9977 Рік тому +1

    So, I have one situation here. Is it possible to make a dropdown column where customers are given the name of the supplier. If the customer selects that particular supplier the column on its left should automatically display that particular suppliers Roll number?

  • @Leekour
    @Leekour 4 роки тому +1

    Shukriya aapka

  • @adilshaikh3792
    @adilshaikh3792 7 місяців тому +1

    Super sir😮

  • @twinklejaiyswal5172
    @twinklejaiyswal5172 6 років тому

    Thank you sir
    Useful drop down list
    Video good exaplane

  • @xlpointacademy5127
    @xlpointacademy5127 5 років тому +1

    Very Nice

  • @hareshchavda3890
    @hareshchavda3890 4 роки тому

    Thank you Deepak... Informative videos

  • @anjuman-e-gulzar-e-panjeta7877
    @anjuman-e-gulzar-e-panjeta7877 2 роки тому

    Informative 👍

  • @yogeshratale4115
    @yogeshratale4115 6 років тому

    Superb video sir i really like it.

  • @1alltimeuser
    @1alltimeuser 2 роки тому

    Yahi kaam aya. 🙏🏽

  • @Bhupesh_Kalal
    @Bhupesh_Kalal 6 років тому +1

    Sir me apke sare vedios save krke dekhta hu ap drowpdoun par ek badi sheet pe drowpdoun lagao jis se sab change ho me office me work krta hu jisme badi badi cansols bani hui product ki so plz ap ek koi badi sheet banao or vedio banao thank u

  • @ABDULLAHkhan-ue4pq
    @ABDULLAHkhan-ue4pq 6 років тому

    Very productive.

  • @tariqmehmood9708
    @tariqmehmood9708 5 років тому

    Bohut acha sir

  • @ekhasti
    @ekhasti 6 років тому +1

    You are a life saver... channel subscribed

  • @anjaneyulukodam9961
    @anjaneyulukodam9961 6 років тому

    Best teacher.
    Good night sir,

  • @thegamingworld8329
    @thegamingworld8329 2 роки тому

    Good information

  • @xlpointacademy5127
    @xlpointacademy5127 5 років тому +1

    Super Sir

  • @ghumansaab2314
    @ghumansaab2314 4 роки тому +1

    Nice Video brother

  • @abhishekbhatt8931
    @abhishekbhatt8931 4 роки тому

    Perfect...👍

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 4 роки тому +1

    🌹🔥 राधे राधे🔥ARK🌹🏹

  • @pallaviagrawal7925
    @pallaviagrawal7925 5 років тому +1

    V nyc video sir

  • @bijaymuduli1171
    @bijaymuduli1171 Рік тому

    Superb sir

  • @omprakashmaurya4924
    @omprakashmaurya4924 4 роки тому

    Thanks for making videos

  • @rohanc2574
    @rohanc2574 6 років тому +1

    Explained in very simple way..Amazing 👍

  • @jaismeetkaur922
    @jaismeetkaur922 4 роки тому

    Thanks sir ji

  • @nishantjain6827
    @nishantjain6827 Рік тому

    Nice work deepak sir

  • @gajendrakarma9228
    @gajendrakarma9228 6 років тому

    bahut badiya

  • @mmmm-xm5fc
    @mmmm-xm5fc 3 роки тому

    You are Excel man

  • @ratishch.senmunna9851
    @ratishch.senmunna9851 4 роки тому

    Very helpful

  • @RamKumar-du8nd
    @RamKumar-du8nd 6 років тому +1

    Thank you sir
    Very good video

  • @gpdispatch1481
    @gpdispatch1481 2 роки тому

    NICE SOUND QUALITY

  • @sanjayameher2022
    @sanjayameher2022 5 років тому

    Nice deepak. Thanks

  • @bikashranjan9711
    @bikashranjan9711 5 років тому

    Dropdown list aur thoda video bhejiye apaka e learning lesson bahut acha lagarahay
    Thank you sir.

  • @maanpal1190
    @maanpal1190 6 років тому +1

    Bahut hi Sundar he video keep it up for helping thanks alote

  • @sarvodayaconventvidisha1757
    @sarvodayaconventvidisha1757 3 роки тому

    जबरदस्त

  • @aliawan1977
    @aliawan1977 6 років тому +1

    Nice work Deepak.

  • @Laxmi_creator.
    @Laxmi_creator. Рік тому

    Thankyou so much dear

  • @pankajknowledgeworld
    @pankajknowledgeworld 3 роки тому +1

    ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai..
    1. main matlab user ek colom main gya jaha sirf customer ka name likh diya..
    ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein..
    aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke...
    2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye..

  • @anilachrist8831
    @anilachrist8831 2 роки тому +1

    Great

  • @neerajjain1270
    @neerajjain1270 5 років тому +1

    Hi Deepak Your videos are really useful, I want to use searchable drop down with this sheet. because my data is very big

    • @DeepakEduWorld
      @DeepakEduWorld  5 років тому

      ua-cam.com/video/bgmEgFyoUSA/v-deo.html. Searchable drop-down for multiple cells 👍

    • @hasmukhparmar3524
      @hasmukhparmar3524 3 роки тому

      I want auto calculator salary bill with worker presence

  • @rajveerSingh-op6hb
    @rajveerSingh-op6hb 4 роки тому +1

    How to extract photos database through dropdown list ?? Please advise