Thank you so much maine kai videos dekhe but usmein formula hide bhi hota tha or cell edit bhi nahi hota tha koi bhi but aapki video mein pata chala ki formula wale cell hide or locked hote hai but uske ilawa baki cells editable hai thankyou for this worthful knowledge
Nice video plz make vedio on this situation "if I have 1 target workbook which is automatically updated from other workbook. in the target workbook sheet cell I want to display date on which that cell was modified from source workbook sheet .thanx
R. Sir, Very interesting, simple way to describe thanks for sharing this.i am fan of your channel. I suggest you please make a video that when we click in a cell whole row and column line will be highlighted.it may helpful in the maintain of large data correctly. Thank Manmohan.
Ye wala Formula hide krna vlookup me b ho sakta hai ? agr han to usme search kese hoga ? means sheet lock hogi to I.D likh k sewrch kese krengy or drop down menu se search kese krengy ?? plz iska ans zrur den. ya ek video bnaen jis me vlook up formulas ko b lock or hide kren or vlook b kaam kry means search ho or result dy. thanks and u r awesome
Sir, i liked ur way of teaching very well. I want to know that how we protect data in same sheet, up to last day. One can feed data for present date, but not edit, delete, last days.
Sir sare videos bhot achi hai mujy na Ap ki formula wali video nae Meli matalb jis mein sare formuly bate gy hn agr ap k pass hai to link kry nae to bna k upload deny plz
Dear Deepak jii maine apke har video ko dekhta hun or excel sikh raha hun lakin maine app se ek request ki thi time sheet with overtime calculation ke sath.
Dear sir, please build a video clip regarding the creation of nemerical and alphanumeric codes in excel. If we write the respective code in any cell then the description of material or item name will appear automatically. I mean this is very much useful to maintain stores inventory in excel workbook. Regards, SUBAL CHANDRA DAS.
Hi Deepak, I have numbers of inspection table sheets for different products and saved in each sheet. I want to open each sheet in new sheet by only one click.
Ms Excel me formula hide kar sheet ko protect karna to sikh gaya. Apka bahut bahut shukriya. Ek problem yah hai ki Excel me hide kia gaya formula Google sheet me unhide ho jata hai, uska koi solution de sake to bahut kripa hogi apki
Thank U Deepak Sir, for this video. men is tarah ki video ko dher sare din se dhoondta tha. but mera man mein ek question hei ki jab men formula use kar ke ek file banata hai aur usko formula hide aur protected bhi kar deta hun.but jab aur kisi ke pass wo file jayega wo bhi apke pichhili video ke jariye unprotec bhi kar sakega thik hei ya nehin.
Good sharing.. Can you help me.. ...i am copying 10 cells which is filled with different amounts and when i am pasting in another workbook it should give me sum of that 10 cells in single cell...
One more thing I want to know.. Is there any way to apply a formula in a cell...bt store as saved formula like data validation.. and also use your own data while needed as searchable data validation. But the formula always work in that cell
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Very fantastic trick sir. Thanks & Regards
Your teaching style is mindblowing. I like it. It helps me also.
Sir app bhut hi acche se smjhate ho.....
Thank you so much maine kai videos dekhe but usmein formula hide bhi hota tha or cell edit bhi nahi hota tha koi bhi but aapki video mein pata chala ki formula wale cell hide or locked hote hai but uske ilawa baki cells editable hai thankyou for this worthful knowledge
thnx deepak its indeed simple language to understand
😊
@@DeepakEduWorld
@Ramesh.?
Nice video Sir
Aap se bahut kuch sikhne ko mil raha hai. Thank You Deepak Sir
Thanks Deepak. It was very useful and clear information.
Such a wonderful and very useful video. Many thanks to EduWorld.
It is what I was looking for Sir love from pakistan
It's to helpful video......
Once again thank you so much....
Awesome.. resolved my problem..
Nice idea 👍👍👍
Nice & thank you.
Excellent Deepak
Nice video plz make vedio on this situation "if I have 1 target workbook which is automatically updated from other workbook. in the target workbook sheet cell I want to display date on which that cell was modified from source workbook sheet .thanx
Nice video thank you very much
🤗🤗🤗
Very important for us.
I am also dipak, i like ur channel.nw upload unique functions which will improving me..
Too easy step....Thank you
R. Sir,
Very interesting, simple way to describe thanks for sharing this.i am fan of your channel.
I suggest you please make a video that when we click in a cell whole row and column line will be highlighted.it may helpful in the maintain of large data correctly.
Thank
Manmohan.
Lot of thanks sir.........God bless you
Advance me very good sir nice video sir
😊😊
Bahut badhiya Deepak bhai..
Thanx bhai. Very good video
It works thank you sir
Excellent..good informative job
Sir. U are Genius.
I like your exercise
Great very useful
🤗
I like so much sir
Deepak Sir Thanks
This is very useful.
Thank you Sir for sharing this video
NICE INFFO
Thanks Deepak sir..really very good job..baht baht Acha laga sir..thanku so much
Thank you so much
Many thanks my friend.
Very helpful, thanks bro
Amazing trick
Very useful and nice
isi work ko google sheet me kaise karenge sir ji, bataiyega please
Hide Formula in Google Sheets - Part 1: BOUNDED Script with Simple Formula
ruclips.net/video/Vkfx_namuOA/видео.html
I was tasked by my boss on the same thing. I found your video which helped me and impressed my boss. Thanks
Great effort
I salute you bro
Jai Hind
+prashant saini jai hind
Sir g apka samjane ka tareeqa bohut he bohut acha heySir ek request hy ap SeTally par b videos nikalo
Ye wala Formula hide krna vlookup me b ho sakta hai ? agr han to usme search kese hoga ? means sheet lock hogi to I.D likh k sewrch kese krengy or drop down menu se search kese krengy ?? plz iska ans zrur den. ya ek video bnaen jis me vlook up formulas ko b lock or hide kren or vlook b kaam kry means search ho or result dy. thanks and u r awesome
Really appreciate and helpful 😊😊👍
Superb video sir
Really mind-blowing technic to detailing. This is very helpful. Please post how to maintain stock in gold showroom
Very Nice Sir.
Nice video
Thanks Deepak
awesome work...
This really useful
Very nice सर
Sir, i liked ur way of teaching very well. I want to know that how we protect data in same sheet, up to last day. One can feed data for present date, but not edit, delete, last days.
Good ques... Well i will publish video shortly on this topic
Grate sir
😊
Sir sare videos bhot achi hai mujy na Ap ki formula wali video nae Meli matalb jis mein sare formuly bate gy hn agr ap k pass hai to link kry nae to bna k upload deny plz
Thanks
I am from Pakistan i like ur teaching style
Thanks alot
You are just great...
Deepak ji
Excel m file menu me excel option hote h Jo
Unke bare m full review ki video bnao
Pls
Thanks sir🙏
Dear Deepak ji, I didnt find that what I need from your this vedio. Can you please tell me how to lock few cell ( Selected Cell) in work sheet.
Ok.. Please watch another video.. To protect formulas in excel sheet.. Link is in description of this video.. Or u can visit our channel playlist
Nice video deepak sir
Dear Deepak jii
maine apke har video ko dekhta hun or excel sikh raha hun lakin maine app se ek request ki thi time sheet with overtime calculation ke sath.
Good formula
Please sir make a video about excel formula such logical sum mathmatical
Nice
Thank u soo much sir
THANKU SIR
Supper Dipak sir
Nice deepak
Sir ji ye trick to thik hai. Copy option jaise kaam na kare kuch trick hai kya
Nice sir gee
You are amazing. Shortcut for goto bhi bta skte the sir jee :D
Thank you
Hi Deepak... Thank you so much for this video.
Dear sir, please build a video clip regarding the creation of nemerical and alphanumeric codes in excel. If we write the respective code in any cell then the description of material or item name will appear automatically. I mean this is very much useful to maintain stores inventory in excel workbook. Regards, SUBAL CHANDRA DAS.
G
Hi Deepak, I have numbers of inspection table sheets for different products and saved in each sheet. I want to open each sheet in new sheet by only one click.
love u bro
Nice but after this trick unable to filter
Any solution sir?
Md Abu Talha Khan ...I m facing same problem
Hi Deepak, I wanted to know how to protect formula in merge cell.
Kya baat sir
Ms Excel me formula hide kar sheet ko protect karna to sikh gaya. Apka bahut bahut shukriya. Ek problem yah hai ki Excel me hide kia gaya formula Google sheet me unhide ho jata hai, uska koi solution de sake to bahut kripa hogi apki
Nice
Om Sai Ram
Sir
Workbook ke formula hide ho sakte hai kya? Only hide
how to hide formula in google sheets ?
Sir multipal print kaise nikale excel ke 1k hi sheet mai
*sir Please reply*
Explain in detail How to use head formula tab
Thank U Deepak Sir, for this video. men is tarah ki video ko dher sare din se dhoondta tha. but mera man mein ek question hei ki jab men formula use kar ke ek file banata hai aur usko formula hide aur protected bhi kar deta hun.but jab aur kisi ke pass wo file jayega wo bhi apke pichhili video ke jariye unprotec bhi kar sakega thik hei ya nehin.
+SANTOSH KUMAR ACHARYA Yas.... anyone can unprotect ur excel password protected file after watching that video.... .
Ek video bana dijie formula ke uper icon conditional formula lagake
super
thanks ! if we select the portion which is only protected, then which type of command we should used !
Here is video that contains if you want to protect only selected area in sheet
ruclips.net/video/DfBoZEOnCFk/видео.html
supper video
Good sharing..
Can you help me.. ...i am copying 10 cells which is filled with different amounts and when i am pasting in another workbook it should give me sum of that 10 cells in single cell...
Jiyo deepak bhai jiyo
😊♥️
One more thing I want to know..
Is there any way to apply a formula in a cell...bt store as saved formula like data validation.. and also use your own data while needed as searchable data validation.
But the formula always work in that cell
I got the solution
Any shortcut for this?...like any function key or anything?