Тёмный

😲 How To IMMEDIATELY Auto Lock Cells After Data Entered in Excel 

Deepak EduWorld
Подписаться 1,2 млн
Просмотров 154 тыс.
50% 1

How To IMMEDIATELY Auto Lock Cells After Data Entered in Excel
#deepakeduworld #Excelinhindi #lockcells
दोस्तों इस एक्सेल के वीडियो में आप सीखोगे की डाटा एंट्री करते ही सेल ऑटोमैटिक लॉक कैसे होंगे ! एक बार सेल में एंट्री कर दी तो कर दी फिर उस सेल में एडिट नहीं होना चाइये ! तो बहुत आसान है ये एक्सेल में करना
in this excel tutorial you will learn How do you automatically lock a cell / protect cell after a value is entered? Once the data has been entered we wish to lock the cells in such a way that we requires a password to make any changes so This tutorial demonstrates how to automatically protect data immediately in excel after it has been entered in a cell.
is excel ke video me aap seekhoge ki cell me data entry kartey hi cell immediately automatic lock kaise ho to bahut sare offices me is Excel Magic Trick ki jarurat hoti hai ki 1 baar jo entry kar di to kar di fir usme koi change nahi hona chaiye to iske liye hum 1 magical VBA Macro ka use karangey
Download VBA Macro Code : drive.google.c...
Download Training File : drive.google.c...
MORE USEFUL EXCEL VIDEOS FOR YOU : -
1. SURPRISING Excel Formula 2020- Most Excel Users Don't Know ( Concatenate cells with line break ) • SURPRISING Excel Formu...
2. 3D Formulas in Excel • Why You Should Use 3D ...
3. Top 5 Excel Tips and Tricks 2020 - Excel Users Should Must Know • Top 5 Excel Tips and T...
4. Very Small Excel Formula ( NetWorkDays ) To Calculate Working Days Between Two Dates • How To Calculate Worki...
5. HIDDEN Excel Trick You Don't Know 2020 - You Never Miss To Use it • Excel Trick You Should...
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepak__nehra
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld RU-vid Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 278   
@amjadmkhan3383
@amjadmkhan3383 4 года назад
RU-vid pe bahut se channel hai.lekin aap ki baat hi alag hai. Number 1 tutor in youtube.
@VisualKreation
@VisualKreation 3 года назад
Jaise Mahasagar me moti bahot dhoondane se milta hai waise hi muze RU-vid ke Mahasagar me Aapka Channel Mila hai...Really Great & Helpful All Videos..TQ
@udaynaththakare7547
@udaynaththakare7547 3 года назад
दिपक जी, मैं आप के वीडियो रोज देखता हूं, आप बहुत ही खूबसूरत ढंगसे समझाते है, आप की सभी वीडियो अच्छे है, पर मुझे जो काम की है,उसे मैं यूज करता हु, बड़ा सुकून मिलता है
@atulshukal4072
@atulshukal4072 3 года назад
बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब
@santoshkasar4503
@santoshkasar4503 3 года назад
Deepak sir you are best Teacher . Sir aise hi ek full video Microsoft Access kabhi Banaiye.
@MrVickybang
@MrVickybang 2 года назад
Fantastic Trick explained by Deepak ji
@patelsir2918
@patelsir2918 4 года назад
Bahut hi achhi hai ye sir ji
@SoHaiL_Khan_64
@SoHaiL_Khan_64 3 года назад
Amazing outstanding vba code superb video bro keep it up..
@avinashverma52
@avinashverma52 4 года назад
Sir, hr video aapka kaam ka hota hai.agar koi seriously kaam krne wala bnda hai to is trh ke video bahut bahut kaam aate hain.mai is video ko pichley 3 years se dhund raha tha.... aapki kae videos ko mila kr mera pura system developed hai jis pr mai roj office ka kaan kerta hun..You are great...love u bro..
@MrChamankumar
@MrChamankumar 4 года назад
Bhai kaha use ki ja sakti yeh sheet
@avinashverma52
@avinashverma52 4 года назад
@@MrChamankumar kisi badi sheet me jb data entry hoti hai to kisi ek bhi cell ki figure, agr galti se change ho gai to puri calculation accidently change ho jati hai.mere sath aisa kai baar ho chuka hai.Cell lock ho jane se ye problem khtm ho gai hai.dusri baat koi jaan-buzh kr aapko nuksan nahi pahucha payga.
@goyalmukeshkumar
@goyalmukeshkumar 4 года назад
Bahut saandar trick sikhate ho aap
@chitragaikar5866
@chitragaikar5866 4 года назад
Very helpful feature and working great
@s.n.zeeshan7273
@s.n.zeeshan7273 3 года назад
Superb sir thank you so much for making the video .this is very helpful for me you are so great ..
@heartqueen69
@heartqueen69 4 года назад
Sir aapke sabhi videos bahut hi helpful hote Hain. Plz sir aap telegram par group or channel bana lijiye . Plzzzzz
@RahulYadav-cf1yo
@RahulYadav-cf1yo 3 года назад
Thanks sir very good
@narendrasaini6264
@narendrasaini6264 4 года назад
Better sir bhut acha
@damodarbangalore7003
@damodarbangalore7003 4 года назад
Sir, It's working fine. Thank you very much...
@saleemkareem4014
@saleemkareem4014 Год назад
Sir so nice of you. please make same action in Google sheet thanks
@caaman93
@caaman93 3 года назад
You alwz Upload Unique Videos.....Thanks
@Mr.KundanThakur
@Mr.KundanThakur 2 года назад
Sir nice video 👍
@umeshbarde5935
@umeshbarde5935 4 года назад
Nice Sir ji Mujhe eski Jarurat thi Thank's
@differentkuber
@differentkuber 4 года назад
Bahut dino aisi video ki mujhe bahut abasyasakta thi thank you deepak sir
@aryashsonkar9204
@aryashsonkar9204 4 года назад
Thank u Sir🙏🙏 Apke video's bht ache h sir mai apke video's dekh kr hi study krta hu sir back invoice button with old entry kaise bnae sir back invoice button to bna liya pr enrty kaise laye purani jo new invoice button pr click krne se clear ho jati h sir pls bta dijiye
@Amjadisbest89508
@Amjadisbest89508 4 года назад
Deepak bahi g main ne ap ke video jo ke row & column ko color hilight karne ka treqa ap ne batya tha wo sub ok he lekan jub ek cell ke andar type kartee hain to undo nahi hota plase us ka koi karka bateen thanks for you Deepak bahi
@vijaymumi
@vijaymumi 4 года назад
Nice trick sir
@srikanthkasala7850
@srikanthkasala7850 4 года назад
Super Explanation Excellent
@prakashsirvisetti6714
@prakashsirvisetti6714 3 года назад
Thank you brother
@jaihind_jaisanatan
@jaihind_jaisanatan 2 года назад
Sir ek video is topic par bhi dalo ki kisi particular drop down list lage hue cell me agar me small lattes me bhi agar type kare to cell selection move hote hi vo capital latter me badal jaye
@sashibhusanmuduli6131
@sashibhusanmuduli6131 Год назад
This is amazing vedio sir....... ❤️
@pramodmaurya1049
@pramodmaurya1049 4 года назад
Sir very good video sir excel mis pr video banaaiye
@navinmehta8721
@navinmehta8721 3 года назад
very good and simple.
@AZIMUDDINAHMAD-c3y
@AZIMUDDINAHMAD-c3y 10 месяцев назад
You are nice man. Always your tips are so helpful. God bless you.
@nadeempakistan50
@nadeempakistan50 4 года назад
bro ,pls make video on ,bank reconciliation and as well as trial balances, because these are very popular matters in professional life
@pandharinathjoshi6565
@pandharinathjoshi6565 4 года назад
Different trick sir👌👌
@nadeempakistan50
@nadeempakistan50 4 года назад
Deepak your are best teacher i had so far, your styles to demonstrate things is best among the others youtubers.
@fardin78672
@fardin78672 3 года назад
You are great sir
@reneehoward-johnson2092
@reneehoward-johnson2092 3 года назад
I love this, it was easy to understand and follow, even thou I don't speak Hindi. Thank you so much
@rajanphadke
@rajanphadke 4 года назад
I like your simplicity , sincerity and teaching style. Thanks for updating 🙏
@EkBaarMuskurao
@EkBaarMuskurao 3 года назад
Mind Blowing sir ji
@heeren.9
@heeren.9 4 года назад
Excellent Sirji
@rajubuddy8476
@rajubuddy8476 4 года назад
Well I'm learning something new in you're RU-vid channel 👏👏👏
@JitendraKumar-zm2xo
@JitendraKumar-zm2xo 4 года назад
Hello sir apki sabhi video bahut hi damdar hoti hain sir Great sir ap society k lie bahut acha kam kr rhe hain. Sir ye jo apne video bnai cell automated lock krne wali isme sir ak bat clear nahi hui apne direct note pad khola vo jo coding thi note pad me vo coding hme khud se type krni padegi ya kahi se source leni hoti hain plz clear kre sir 👌🙏
@inderrajchanauria8221
@inderrajchanauria8221 4 года назад
very nice I was looking for this since long thanks a lot
@advgovindtiwari8795
@advgovindtiwari8795 3 года назад
I think I may not have learned as much as I have learned from you. Big Thanks Bro.
@jitendrabomble2218
@jitendrabomble2218 2 года назад
Nice. Very important information.
@moodkn
@moodkn Год назад
Excellent... Excellent... Thanks
@amarcreation6388
@amarcreation6388 2 года назад
Bhai Google sheets me same lock kaise dale please make video on that. Help please
@theblessing1719
@theblessing1719 4 года назад
Let's begin the topic, bhai ye aap bahut mast bolte ho,
@DeepakEduWorld
@DeepakEduWorld 4 года назад
😊😊😊
@deepaksaraswat7641
@deepaksaraswat7641 Месяц назад
Great work
@talksuspense
@talksuspense 4 года назад
Nice information
@mohdshahbazkhan878
@mohdshahbazkhan878 Год назад
Hi sir workbook ko kaese protect krein pls make one more video
@rajadey1552
@rajadey1552 Год назад
I am your big fan. I always watch your videos, and I find your videos very useful. Sir, I am making a request to you, if you could make some videos on google sheets and apps sheets, it would be very helpful. I look forward to your videos. Hope you will accept my request and make some videos on this topic soon.
@PankajKumar-is7zq
@PankajKumar-is7zq 4 года назад
Wow what a tips I most like your post Please dile aharing ka video post kijiue
@SA-yy3wd
@SA-yy3wd 2 года назад
Thank you
@rajsahu1029
@rajsahu1029 4 года назад
Very interesting and useful for some advance work. It may be use also in typing test in excel data
@afzalmalakwal4649
@afzalmalakwal4649 Год назад
Verry nice bro
@bhaveshparmar431
@bhaveshparmar431 4 года назад
Extraordinary
@rakkiyadav1483
@rakkiyadav1483 2 года назад
Amazing explanation. SuperB content.
@LiaqatAli-qk8yp
@LiaqatAli-qk8yp 3 месяца назад
Amazing
@SamirKhan-qs8nn
@SamirKhan-qs8nn 2 года назад
Thank you sir.
@calculatorolo6185
@calculatorolo6185 4 года назад
Brilliant sir 👍
@shyamsunderdas3524
@shyamsunderdas3524 3 года назад
Sir, very helpful all of your educational videos. If possible please share "full tutorial about table tools formulas in excel"
@sudhirgouti5431
@sudhirgouti5431 3 месяца назад
Pl explain can we lock multiple cell in different parts of worksheet
@rana1018
@rana1018 4 года назад
Very nice sir
@diptendupaul3070
@diptendupaul3070 4 года назад
mara list sheet 1, gst billing sheet2 no, job mamna drop list lata ok, but billing ma vlookup , drop down nai latA hai, list hota vlookup hota nai. hab solve kar dija.
@rana1018
@rana1018 4 года назад
Sir kindly jo billing hai ap ny dkha us pr kch bna dein
@kousiksamanta8784
@kousiksamanta8784 3 года назад
Aswome trick sir.
@nitinsingh.2107
@nitinsingh.2107 4 года назад
Very good Deepak
@jimmykhan5627
@jimmykhan5627 4 года назад
Very very good, #educationadda1
@dilipdeka4462
@dilipdeka4462 4 года назад
Run macro protect sheet.. Plz video banaye please
@BrijeshKumar-qx2bk
@BrijeshKumar-qx2bk 2 года назад
Acha lga lekin vbg coding ki video banaiye basic se
@AmnaIkram-mt4ey
@AmnaIkram-mt4ey 5 месяцев назад
Sir delete restrictions bhi batayie takeh koi delet bhi na Kar saky
@TechKnowGuide
@TechKnowGuide 4 года назад
Saved in watchlater...love u....keep posting thxx
@barundevdas6917
@barundevdas6917 4 года назад
Your tutorials is praise worthy & very much useful. Thanks alot. One thing regarding this video is that when I reopen the work book, auto lock is not functioning any more in the rest blank cells.
@Techtoguide
@Techtoguide 4 года назад
Super Work Hai bro.... Love you bro..
@bbuschy5883
@bbuschy5883 4 года назад
sir you are amzing 😄😄😄😄
@radhekrsna007
@radhekrsna007 4 года назад
Wow. Too good
@jawadkhan4786
@jawadkhan4786 4 года назад
Wow... Creative idea...
@mncreation674
@mncreation674 5 месяцев назад
nice job❤
@KuchhBaatMereSath
@KuchhBaatMereSath 2 года назад
I💕 यू सर आपकी मेहनत को
@JeevikaandMiteesha2806
@JeevikaandMiteesha2806 Год назад
Amazing, Hatss Off
@exceling3820
@exceling3820 3 года назад
দাদা, আমি বাংলাদেশ থেকে বলছি। আমি আপনার প্রতিটি ভিডিও দেখি এবং আপনার খুব ভক্ত। আমি আপনার ভিডিও দেখে অনেক কিছু শিখতে পারছি। আমি একটি বিষয় জানতে চাই তাহলে সেল পয়েন্টারকে যে কোন সেলের ভিতর স্থির করতে রাখতে চাই যাতে নড়া-চড়া না করতে পারে। প্লিজ হেল্প মি
@vijaybhairavjibhaiode2357
@vijaybhairavjibhaiode2357 4 года назад
Very nice.......
@sumitkahar5113
@sumitkahar5113 4 года назад
Excellent Video... But I want to lock cell after completing last entry of the row... Is it possible??
@mdaslamniit
@mdaslamniit 4 года назад
Amazing trick 👍
@baskaranvaradhan2369
@baskaranvaradhan2369 3 года назад
Super
@PAPPUKUMAR-zx8le
@PAPPUKUMAR-zx8le 3 года назад
Nice
@hirasva
@hirasva Год назад
VERY USEFUL VIDEO BROTHER, CAB IT BE POSSIBLE IN GOOGLE SHEET?
@mayanabachhar9584
@mayanabachhar9584 3 года назад
Excellent sir
@gauravmundhra3086
@gauravmundhra3086 3 года назад
Aap Google sheet me after entry cell automatically locked ka vedio daale
@atulshukal4072
@atulshukal4072 4 года назад
Very good Sir Thenks
@rajeshsharma-kk8qh
@rajeshsharma-kk8qh 4 года назад
Very Good
@balvantkushwah4646
@balvantkushwah4646 4 года назад
Liked your vedio
@Test_yourknowledge
@Test_yourknowledge 4 года назад
Thanks sir Thank you so much ❤️😊
@sumitsaha3267
@sumitsaha3267 3 года назад
Deepak sir yeh video mera bohot helpfull raha.. lekin sir kiya mujhe bata sakte ho k , mujhe data entry kitna karna hai pata nahi, lekin mai new entry karta chala jau aur cell automatically lock hota chala jaye... Kiya aisa ho sakta hai?
@ashoksahu9546
@ashoksahu9546 4 года назад
Wahoo. Excellent video.
@mahendrachauhan2224
@mahendrachauhan2224 4 года назад
Awesome sir
@pakscaffoldinginternationa6604
@pakscaffoldinginternationa6604 10 месяцев назад
kiya ye hi trics google sheets par bhi apply hojayegi sir kindly inform karde.
@majidsiddique8227
@majidsiddique8227 4 года назад
Wonderful trick
@kirparampokhriyal8195
@kirparampokhriyal8195 3 года назад
Nice trick
@differentkuber
@differentkuber 4 года назад
Video jabarjast hai but sound problem bich bich hui
@nazairsaifi
@nazairsaifi 3 года назад
Thank to you sir ..😨😨😨 this is very used full for me..
@mylifeintheuk2093
@mylifeintheuk2093 4 года назад
Do you provide any personal help too ? Or provide custom made format !! Many Thanks
Далее
PUBG Mobile СТАЛ ПЛАТНЫМ! 😳
00:31
Просмотров 108 тыс.
EASILY Make an Automated Data Entry Form in Excel |
9:56