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
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.
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
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.
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.
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.
How can we hide & lock the important formulas in a specific cells in excel sheet ( ie the common / normal formulas in other cells will be displayed ) . is any such options in excel ?
Very helpful videos.. i want a solution if any worksheet is protected with password n formulas are hidden so can we remove password and see the formulas... If yes kindly help by videos...
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...
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.
hello sir, aapke pas koi aisi formula ka video hai jisme ek sheet1 me koi name hai to hm jaise hi us name pr click kre to sheet2 me saved us name pr wo direct mujhe lekr chle jae ..agar aisi koi video hai to please us video ka link mujhe share kijie.. thanx
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.
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
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
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
Sir app bhut hi acche se smjhate ho.....
Very fantastic trick sir. Thanks & Regards
It is what I was looking for Sir love from pakistan
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.
Your teaching style is mindblowing. I like it. It helps me also.
Bahut badhiya Deepak bhai..
thnx deepak its indeed simple language to understand
😊
@@DeepakEduWorld
@Ramesh.?
It's to helpful video......
Once again thank you so much....
Too easy step....Thank you
Nice idea 👍👍👍
Awesome.. resolved my problem..
Very nice सर
Excellent Deepak
Lot of thanks sir.........God bless you
Sir. U are Genius.
I am also dipak, i like ur channel.nw upload unique functions which will improving me..
Excellent..good informative job
It works thank you sir
Thanks Deepak sir..really very good job..baht baht Acha laga sir..thanku so much
Nice & thank you.
Superb video sir
I was tasked by my boss on the same thing. I found your video which helped me and impressed my boss. Thanks
Really appreciate and helpful 😊😊👍
Great very useful
🤗
This is very useful.
Many thanks my friend.
Advance me very good sir nice video sir
😊😊
I like your exercise
Thanx bhai. Very good video
Very important for us.
Very helpful, thanks bro
You are just great...
Amazing trick
Grate sir
😊
Thank you Sir for sharing this video
Sir g apka samjane ka tareeqa bohut he bohut acha heySir ek request hy ap SeTally par b videos nikalo
Great effort
I salute you bro
Jai Hind
+prashant saini jai hind
awesome work...
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.
Very Nice Sir.
Thank you so much
I like so much sir
Nice video deepak sir
This really useful
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
Very useful and nice
THANKU SIR
Thanks Deepak
Really mind-blowing technic to detailing. This is very helpful. Please post how to maintain stock in gold showroom
Click Subscribe if you found it helpful - Be Vocal for Local . Jai Hind
Hi Deepak... Thank you so much for this video.
Supper Dipak sir
Thank you sir
😊
Jiyo deepak bhai jiyo
😊♥️
I am from Pakistan i like ur teaching style
Thanks for this video sir and very 9c trick
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.
Good ques... Well i will publish video shortly on this topic
Waw 👍👍👍
Thank u soo much 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
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.
Workbook ke formula hide ho sakte hai kya? Only hide
Nice deepak
Hi Deepak, I wanted to know how to protect formula in merge cell.
love u bro
Thanks alot
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.
NICE INFFO
Sir iske uper koi conditiona formula laga payege kya
Deepak ji
Excel m file menu me excel option hote h Jo
Unke bare m full review ki video bnao
Pls
Good formula
Please sir make a video about excel formula such logical sum mathmatical
Nice
Om Sai Ram
Sir
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
You are amazing. Shortcut for goto bhi bta skte the sir jee :D
How can we hide & lock the important formulas in a specific cells in excel sheet ( ie the common / normal formulas in other cells will be displayed ) . is any such options in excel ?
Use google sheets and apps script
Sir multipal print kaise nikale excel ke 1k hi sheet mai
*sir Please reply*
Sir
Ms excel ke Pivot table me opening balance, receipt, total, consumption, closing balance kaise nikalenge
Very helpful videos.. i want a solution if any worksheet is protected with password n formulas are hidden so can we remove password and see the formulas... If yes kindly help by videos...
Please watch this video ruclips.net/video/M51S0-kqoKg/видео.html
Thank you so much...
Google sheet ke liye bhi yesi koyi trick h key sir
Sir please make a video on how to make a calendar in ms excel
Ok g
is there any formula which compare two coloums or cells and results are automatic saved in third cell
Not yet... But i ll publish video shortly 👍
Sir ek cell me 10 volume hai usko ten row me Lana hai
Very Very nice information, but can we hide Hyperlinks? If yes ,please.share
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...
Nice
Nice but after this trick unable to filter
Any solution sir?
Md Abu Talha Khan ...I m facing same problem
Nice sir gee
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
Any shortcut for this?...like any function key or anything?
hello sir,
aapke pas koi aisi formula ka video hai jisme ek sheet1 me koi name hai to hm jaise hi us name pr click kre to sheet2 me saved us name pr wo direct mujhe lekr chle jae ..agar aisi koi video hai to please us video ka link mujhe share kijie..
thanx
+Vishwajeet Singh abi nahi hai... But i will publish
Deepak EduWorld OK sir m extremely waiting for the video
Sir ji ye trick to thik hai. Copy option jaise kaam na kare kuch trick hai kya
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.... .