Sir , would this drop down list applicable to multiple cells in a sheet ? Please clarify . Thanks ..you are too good at clarifying basics on the topics you touch .
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?
Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.
Dear sir. Namaskar. Bahut achchha video banaya hai aapne like to banta hai. Sir eska advance kuchh banaeye jaise esme surch box me likhne par hi drop down list ban jaye esme drop down list surch karna padta hai. Dusra jaise Rajasthan state surch karu to dusra drop down zila ka ban jaye jo usme feed kiya gaya ho aur usko inter karne par box me feed ho jaye please sir es par video banaiye.
sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable
good morning sir i want that with the help of drop down list the whole sheet or selected data can be changed and in its place other data will come please send video related to it
sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable
Thanks
Thanka
Very good video. You have tought the simplest way to produce blank free list. This will be a great help. Thank you Sir.
आपके सभी वीडियो अत्यधिक जानकारीपूर्ण हैं. मैं आपसे एक्सेल का उपयोग करके इनवॉइस जनरेशन और डेटाबेस प्रबंधन के बारे में सीखना चाहता हूं।
Excellent video in simple Hindi language.
Perfect Example .... it helped me !!
Thanks sir.
Very useful information.
👌👌👍👍🌹🌹
Best solution ever ... thanks
Excellent tutorial, Thanks for sharing.
Clear and detailed explanation. Thanks
Thank you Sir ...learnt a lot from this
Very nice sir good job
very nice video.. i like it
Sir , would this drop down list applicable to multiple cells in a sheet ? Please clarify . Thanks ..you are too good at clarifying basics on the topics you touch .
Very knowledgeable video
Nice clarification.
Good Job done
Thank You for sharing 🙏
If I want this formula in continue rows for different data then or I can use the same formula next cell also possible
Excellent..
16:40 offset video Link in i button
👍👍👍
Realy nice, but I want to make multiple searchable dropdown list. Is it possible shortly, guide me.
CAN U PLEASE EXPLAIN HOW TO CREATE SEARCHABLE DROPDOWN LIST IN EXCEL 365 USING MULTIPLE SHEETS
Thank you
Realy Nice, but I want to make searchable dropdown list. is it possible shortly, guide me.
Kia 2nd sheet sy bhi same way mai searchable drop down list Bana saktay hai like data on 2nd sheet and drop down on other
आपसे कैसे संपर्क करें । आपके सारे विडियो बहुत अच्छा है ।
@ComputerGyanGuruji
Any formula for select multiple value from dropdown list without VBA or MACRO.
Super sir , agar list nahi but array ho to kaam karega ??
Thank you very much for your valuable information. I do appreciate your effort for giving us these lessons.
Sir, search in a single cell but In my data required row wise search then pls guide me
Excellent
Nice Sir
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?
Dear Sir,
Can we use created hyperlink into another system.
For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.
Dear sir.
Namaskar. Bahut achchha video banaya hai aapne like to banta hai. Sir eska advance kuchh banaeye jaise esme surch box me likhne par hi drop down list ban jaye esme drop down list surch karna padta hai. Dusra jaise Rajasthan state surch karu to dusra drop down zila ka ban jaye jo usme feed kiya gaya ho aur usko inter karne par box me feed ho jaye please sir es par video banaiye.
upload soon
DEEPAK KI 'HOW TO MAKE DEPENDENT DROP DOWN LIST DEKHO'.
How to make balance sheet consolidated in Excel for the year
Well done
Sir,bahut fast teach karte hai aap
kya hum drop down list ko a to z sort kr sakte hai ????
It must be applicable to multiple cell, but it only for one cell.
Sir what is the wildcard for numbers
Please tell me 🙏🙏
very good, but How to set every row, Because I need to search name for every row's entry
Sir, what is the difference between product function and mmult function explain examples..
Nice
what if "B2" is not fix and goes on increasing as in input data in i.e i want to do the above video proceudure in all the colums "B"
How to copy this data validation to other cells
How can create only first character searchable drop down list in ms excel 2007 in hindi
sir mujhe dusri sheet pr drowdoun list banna hai or 40 row me lagana hai
How we can use this in VBA
sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable
Sir ye multiple cells pe Kam karega??
Data validation isn't working show this one(the source currently evaluation to an error)
I have a sheet which updates everyday , to usme 20 names ki jagah next day 25 names aa jaayenge to kaise hoga ye
SIR PLEASE HELP, WHEN I PASTE OFFSET FORMULA IN DATA VALIDATION THAN ERROR LIKE (the source currently evaluates to an error)
plz try correctly
Good
How to use searchable dropdown list in multi cell.
Excel 2007 me filter wala formula kase add kare
how to use it in another sheet?
मैं आपके पूरे वीडियो देखा लेकिन मुझे जो जानकारी चाहिए वो नही मिल पा रहा है। कृपया मेरा सवाल का उत्तर देने का कष्ट करेंगे
2007 version ke liye chahie use per yah Kam nahin kar mujhe pure column mein dropdown chahie
Other tab par offset formula data validation main work nahi kar raha.
गुड सर.
सर राइट किलीक ना करके सेल मे लिखने पर ही नीचे ड्राप डाउन लिस्ट बनती जाए ऐसा कुछ बनाइये🙏 प्लीज सर.
good morning sir i want that with the help of drop down list the whole sheet or selected data can be changed and in its place other data will come please send video related to it
yeh sab formula cell phone me karke batao sir pls
गुरूजी यदि हम दोस्तो को गूगल शीट साझा करें , तो दोस्त हमारी शीट पर कोई फोटो कैसे अपलोड कर सके
noted
Sir aap email address sent kijie me aapko ek excel file batana chahtu hu kyoki usi excel file me cell me jitne number likho utni hi row open hoti he
jangirgolums2@gmail.com
बहोत complicated hai. ईसाका VBA code banao सर
This is unusefull because its only for one cell so its crap
Thank you
sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable