Excel मे सीखो एक interesting 👌 Trick - Show/Hide Data Based On Drop-down List😮

Excel में ये आपने ये नहीं सीखा होगा - Excel Super Interesting Trick - Show & Hide Data Based On Dropdown List in hindi - this is really very interesting topic friends, you can hide & show worksheet data based on data validation dropdown list. its very easy & may be very helpfull for you.
Download Training File : drive.google.c...
Advanced Excel 5 Super Hidden Secrets & Data Hiding Tips & Tricks To Make You SmArT
• 😮 Advanced Excel 5 Sup...
Vlookup In Excel - VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. VLOOKUP With MATCH Function In Excel
• How To Use VLOOKUP Wit...
8. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
9. Hlookup With Match Function in Excel in Hindi
• Advanced MS Excel - Hl...
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
________________________________________________
ADVANCED MS EXCEL ► goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS ► goo.gl/bbHYu2
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER Tips & Tricks ► goo.gl/paZmpn
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Subscribe to my channel ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
**********************************************
Thanks for Watching
Happy Learning
ER DEEPAK NEHRA [ M.Tech. ]
**********************************************

[@DeepakEduWorld]

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

[@whitedove6878]

Very Useful and excellent step by step guide

[@avinashverma52]

Sir, Aap mere liye hi videos bnate hain,aisa legta hai.Great Sir..

[@paruljoshi3770]

👌 nice I love ur sentence " let's begin the topic" 😊😊😊

[@KumarAnalytic]

parul joshi do you really love them?

[@mohammadnaseer6341]

Great Video.

[@Alli21]

Kamaal trick, courtesy Deepak&" "&Sir🙏

[@anuragsharma2668]

Amazimg trick ❤

[@thakurgayathri8140]

lajawab sirji

[@AnilKumar-go7hj]

Maja to aa hi gya hai very nice video sir ji

[@navneetthakral982]

Great ,so useful ,thanx a lot Deepak

[@taruntarun4319]

MR. TARUN NICE VIDEO SIR

[@Shorthandwithsunitainm.v.3]

Seriously mazedar tricks

[@shaukatsamad2510]

Mr. Deepak u are excellent , the job which u have done is remarkable that we are learning lots n have desire to
learn more from u ..... that v can stand up infront of others.... thnx for teaching us...

[@yashprajapati9981]

Super sir ji😘😘😘😘

[@samirandas4274]

Very nice 👌

[@ashoksahu9546]

very very nice video

[@kirandeepchoudhry9232]

Awesome Deepak Sir, Sir Can you plz make video custom formatting like there many options in custom like @---;:::: like this etc etc plz make it soon

[@DeepakEduWorld]

G

[@mdks1012]

Good

[@zahidakram8899]

You are my great sir! U r deserve for 1M subscriber

[@RohitKumar-uy7cx]

Awesome vedio sir

[@sajalrahaman4719]

Thanks

[@pareshjadhav1838]

Nice thank u sir

[@salauddinkhokon5596]

Very nice tutorial you are creating all time. I have a question how to calculate data based on drop-down list

[@banditajena3124]

Nice
Important thing for us.

[@khemrajrana7322]

Nice depak ji

[@khuranagee]

Excellent

[@kirandeepchoudhry9232]

Awesome trick but one can see ;;; in custom formatting

[@syedikramullah1114]

Excellent bro love from🇵🇰

[@shekharchakraborty3471]

Dipak sir please upload some video on vb lesson. Your teaching technique is very nice. So waiting for that

[@ajaykarmakar80]

Advance excel me ak sath... If, and, Or farmula ka ak Vedio Uplode koriye Sri..

[@pakparigaming14]

Thanks Sir G...

[@pandharinathjoshi6565]

Nice sir, sir if another row updated it will show update list or can I convert Table format sir...pls confirm sir

[@Pardeepkumar-yt1sd]

Wow 👌 sir

[@sheikhmuhammadadnan3]

very nice

[@Rajinteriorpatna]

Good job brother
DoS pe vedio bnao bhai
I need

[@chandan7908]

Nice guru g

[@vipulmedico2015]

Really magic trick

[@yudichouhan2812]

Jai hind sir

[@vishalchandrani2962]

Very useful video ...Esa koi video he jisme list me se same name sort out karte same name ke total numbers display ho jae ..

[@krmotionexcel]

Great trick forever.........sir ji.
" Condition formatting " I love it......
@ Query:-
Muje condition formatting se ek idea aaya He suno .......
Muje easi task list banani he ki mera task ki last date nikal jaye to Muje bar-bar Excel sheet me msg aaye ki " Task complete Now " , or ye Bar-Bar show ......... Kya ye ho sakta he kya ????????
🖱🖱🖱🖱🖱🖱🖱🖱🖱🖱🖱🖱

[@khiladirullxx9665]

Cogratulation sir

[@sanjeevareddy3459]

Sir make video on exl data file to xml. File

[@yudichouhan2812]

Please publish excel power query basic video

[@gmailid3934]

Thakns sir . Ap kon SA software use karte ho video recording or editing ke Liya . Plz give me download link

[@poonampk4319]

Nice sir

[@zahidakram8899]

Sir , plz now make videos on visual basic

[@bikramkesharipradhan6061]

Sir SQL data import to excel aur uska use shikhayie

[@Mirzaiiui]

Invoice ki all products save krna b teach kr den eg. 10 pencil 20 rubber

[@TahirKhan-zc6zl]

Great job Mr Deepak Bhai Kiya aap stainless steel pipe k liya koi stock list aur sale purchase ke koi Sheet bana k Meri help kar saktay ho . Humaray pipe ma unit 2 forms ma hotay Hain no. 1 (kg) no. 2 (ft) aur pipe may Humaray pass 10 rates aur 10 catogaries Hain. Please help Thanks.

[@sandeepbhargava2714]

Deepak ji kya drop down ki base per rows ko bhi hide kiya ja sakta hai

[@DeepakEduWorld]

I ll research on it.. and publish video shortly

[@ronakgujarathi]

How to unhide & hyperlinked same sheets by Dropdown menu

[@kesarb.k1109]

Deepak sir namaskar aapka video bahut helpful hotahe last video may bahut kuch sika lekin thodisi problem aaya 2. Lock Scrolling Area par. agar may file ko save karke close karu fir file open kare to scrolling lock kam nahi karta plz sir help me. Same request other ur video also From dubai.

[@Rahul_Seth]

Excellent Deepak brother....brother kya aap Koi institute chalate Ho?

[@DeepakEduWorld]

No

[@singhalmonica]

Is this possible to make it dynamic, means if i add new data, then also it would work.....

[@debadattaudayasingh1394]

Deepak sir agar bahat jyada data ho tab to hum ase ek ek karke select to nhi kar sakte... Us time hame kya karna chahiye?

[@DeepakEduWorld]

debadatta udayasingh i will publish another video regarding this issue.. Shortly

[@debadattaudayasingh1394]

Deepak sir i m waiting 4 that video..thank u

[@jikcomputers4889]

Sir Ko time nahi milta hoga is liye sirf likh dete hai. I will publish shortly. So Don't wait for that......

[@kaushiksaha425]

Sir ,
I have some data in my office , and it's filled up with daily wise manner ! Different date, different production and different entry . I want full automatic data filled manner like attendance sheet , which you are provided.
Please provide me a vedio regarding this problem!
Kaushik Saha

[@gajendrakarma9228]

nice video sir
sir ek problem ka solution bataye
jb data bahut bada ho or bhut sari cell me formula laga ho to sheet pe kam karte samay formula ke badalne ka ya galti se delete hone ka dr bana rahta he to formulo ko protect kese kare

[@mohammadaamir1148]

right click on the cell in protection lock the cell then right click on the sheet tab protect then select locked cells...

[@mamtachohan5068]

Sir aesi koi video banao jis me data hide ho jae or or usme password laga sake

[@DeepakEduWorld]

Okay g

[@mariantonys]

The trick is ok sir, but the data are scattered and no numbering. You showed a video about Advance Filter where numbering was don and all data were arranged one after the other.

[@saurabhpadaliya4978]

Dear sir can you please tell me that how can we create new invoice with the help of our previous invoice by removing the details of old invoice like name,items,rate and qty etc.If the video is already posted by you then please give the link or description of video.

[@KumarAnalytic]

SAURABH TECHNOLOGIES sir template bana lijiye easily hoga. share your mail id I'll send you the video

[@saurabhpadaliya4978]

S Kumar [e-mail]

[@arjunram8461]

सर excal मे किसी Data को filter करने पर dropdown list मे show होने वाली list हमेशा English मे ही show होती है जो excal sheet मे हिंदी font मे fill up की गई है
इसलिए निवेदन है कि excal मे filter करने के दौरान show होने वाली dropdown list को हिंदी font मे show करने का /देखने का कोई तरीका है तो please, video का नाम बताने की कृपा कीजिए

[@DeepakEduWorld]

Ok g

[@samiurrahman9174]

Sir aapse request h plz computer m kon course kare jo mujhe bahut jyada fayda ho plz sir jarur advise de sir request h aapse....

[@shubhammanjhi787]

Sir ye to limited data par kaam karegi is tarah se yadi hume unlimited data par ye trik apply karni ho to kese kar sakte hai plzzz reply kijiye......

[@p.k.sharma3838]

Deepak sir. Sheet ko protects krne k bad hum Data ko CTRL + F find command se kaise search kre. Plz help me

[@subhradebnath950]

Deepak sir a trick k andar jo category hain jab bohat jeyda hoga tab easihi bar bar karna pare ga

[@sahilpasricha2518]

Sir flyer hatana aur lagana ka shortcut key kaya hai

[@wasimgauri6064]

how to make keystrokes wise searchable drop down list

[@mehulmaldhari9126]

😲

[@nandkishore9014]

Sir How can we get subtotal in excel header footer. Dynamic value according filters apply

[@KumarAnalytic]

Nand kishore use =subtotal (101,range)

[@siddharthroy27]

Hi Deepak,
Siddharth roy here I trying to use this data but my data size was bit large and also multiple data are there it's not possible to select the data one-one any shortcut plz

[@khalidalisubhanallah2947]

Thanks nice video but my question k jab hum data show Karin to un may cell gab na Ain.

[@DeepakEduWorld]

Ys.. Iske liye vba use karna padega g

[@badaldas2113]

I want to know how to filter,sort.i have it gone wrong numbers are not assending

[@ghumansaab2314]

Brother mene kyi baar pocha hai ap btate nahi ho muje ( 1 kg, or 0.5 kg format) ek hi coulam me lgana hai kaise lagaye gy please btado bhai

[@jimmykhan5627]

Just don't know where to use this trick
Please tell me where can I use this

[@pradeepmore5614]

Sir ji-Gmail ka password bhul jane pr login kese kre bataiye

[@DeepakEduWorld]

Click on forget password.. While logging in.. And follow instructions

[@sameerabdul4540]

How to un-hide drop down list ?

[@bipinpatel932]

English number to gujarati

[@ajmalshahtravelling7088]

a

[@paruljoshi3770]

Hello sir Har Monday vidio publish hota he es Bar kya Hua????? Aap Thik to ho 😊😊😕😕

[@DeepakEduWorld]

G.. Thodi health down hone ki vaghe se video publish ni ho paya.. Thanks..

[@paruljoshi3770]

OK take care vidio KI chinta nahi he sir worried about you. ☺️☺️☺️

[@SanviPatil2019]

सर मैं एक बैंक employee हूँ, मुझे मेरी।बैंक ने किस किस बैंक में investment की है, और कब कब उसकी maturity date है, और कोण कोनसे month मै , कोनसी FD मुझे renewal के लिए भेजनी है , यह सब रिपोर्ट मुझे एक क्लिक से पता चलना कि चाहिए। मेरी हेल्प करो मुझे VBA ,या PIVOT टेबल की मदत से ये कैसे निकालना है, यह सिखाओ।।
आपको बता दू की मैंने एक एक्सेल फाइल बनाई है, उसमे मैंने कुछ ऐसे कॉलम बनाये है, उसमे 1) Date of Deposit 2) Depo.in Bank name (which bank) 3) Deposit amount 4) deposit for month 5) Maturity Date 6) Maturity amount 7) Interest Received
पहिला सवाल 1)मुझे मेरे बॉस ने बोला की भाई हमने किस किस बैंक में कितनी कितनी इन्वेस्टमेंट की है
2) कोन कोनसी FD किस किस MONTH को MATURITY डेट बोलो, या AMOUNT बोलो,
3) हमे किस किस MONTH में FD पे कितना कितना ब्याज मिलने वाला है उसकी टोटल बोलो,
4) हमने किस किस बैंक में 1-1 महीने के लिए कितनी FD की है, या उससे ज्यादा महीने के लिए की है, तो कोनसी बैंक में की है यह बताओ,
तो सर मुझे आपकी इस एक्सेल SHEET बनानेमें मदत च्याहीये, PLZ और वह शीट।मुझे।मेल करो मेरा Mail Id- [e-mail]

[@KumarAnalytic]

vikas bhalekar ise ap pivot table and slicer se easily kr loge. no need to vba. please try if not succeed mail me [e-mail] or whatsapp me [phone]

[@frischmannwainganga7219]

Useful trick....Thanks

[@nileshpetare07]

Nice Deepak sir

[@sanidash6302]

Thanks